Hi All,

I am faced with a scenario wherein while data flow from source to target, a condition would be checked that if the data is present in target then a source column will be updated as U and if the data is not present in target then the source column will be updated as I

Vipin

• Nov 11th, 2014

Lookup the target table based on key and check either record is exist or not. If Lookup returns any record then By using update Strategy update or insert. Note : to update record using Update Strategy you need to apply Primary key at INFA Laval at least otherwise it wont work.

KJ

• Nov 10th, 2014

Its never the source but the target column that gets updated with U or I to identify the updated or newly inserted rows.

Answer Question  Select Best Answer

Nagas

• Nov 24th, 2014

Use the SQL condition "Between and AND" as a filter condition in the mapping

naveenkumar

• Oct 14th, 2014

Execute the target table for mapping to table

Answer Question  Select Best Answer

BRAHMAIAH

 Profile Answers by BRAHMAIAH Questions by BRAHMAIAH

• Dec 30th, 2014

There are 3 ways are available to generate sequence numbers with out using Sequence Generator Transformation, 1) Using Exp Tfn variable concept v_cnt(v)=o_cnt+1 o_cnt(o)=v_cnt 2)using mapping variabl...

Venkateswara Rao Rajanala

• Oct 14th, 2014

You can use output port and say CUME(1).. this will automatically generate the sequence or use Variable port
Var= var+1 and Output port = Var...This will generate the sequence for you

Answer Question  Select Best Answer

Hi Folks,

I have scenario like, I have ten flat files to be loaded in to target but I need to load file names in to a table in mapping level. I think we can do achieve though TC transformation. Unfortunately I did not get though.. Please advise how to implement the logic. ( I need to capture in mapping level only).

This question has been asked one of the interviews.

BRAHMAIAH

 Profile Answers by BRAHMAIAH Questions by BRAHMAIAH

• Dec 30th, 2014

Hi folks, If all files have structure then we go for Indirect file method.we set this property at session level by selecting the source def. After define of the source def at mapping level just do...

Mayur

• Jun 23rd, 2014

Got to flat file properties and there you will find one icon Add FileName column to this table just click on that option and you can able to add currently processing file. Thank you

Answer Question  Select Best Answer

Can any one please tell me how to explain Manufacturing Domain Informatica project in interview as a ETL Developer and from where to start and end.

pradyumna sahoo

• Jan 28th, 2015

Shortly u describe your projects like project name ,& which domain u work? basically u tell your project architecture and its flow .

vijay

• Nov 27th, 2012

Start your project description, then move on to your role and responsibilities and then about your team and so on...

Answer Question  Select Best Answer

Anjali

• Feb 1st, 2015

Suppose we have two dim Dim_Location and Dim_Customer then how in fact table we can map values of Loc which are corresponding to a customer , if loc has val 1 for Chennai and 2 for Bangalore then how we can show the corresponding loc values for cust ?

prasadns26

 Profile Answers by prasadns26 Questions by prasadns26

• Jul 18th, 2006

hi,usually source records are looked up with the records in the dimension table.DIM tables are called lookup or reference table. all the possible values are stored in DIM table. e.g product, all the e...

Answer Question  Select Best Answer

Source
id,name
1,a
2,d
3,c

Target
detail
((1/a)(2/b)(3/c))

Manas

• Feb 4th, 2015

We can use expression transformation here in which we can define variables that store the string in the below mentioned way: var1=var1||(||id||/||name||) output_port=(||var1||) After this w...

XYZ

• Feb 4th, 2015

Using a Union Transformation

Answer Question  Select Best Answer

HiIam learning informatica 8.1 ( which is what i could get my hands on)..I am connecting to oracle 10g.I created 2 connections to the DB using Connection --> Relational Connection Browser.The Source and Target are the same db in this case, just diff table names. But created 2 separate connections .I 1st created the TUTORIAL_SOURCE and then copied it to TUTORIAL_TARGET and gave it a new name. then...

Gatla Dileep reddy

• Feb 16th, 2015

It is a DB issue, If the Session failed in middle just try to recover the workflow.

Vids

• Aug 13th, 2013

The error seems to be DB error . First of all , check at the database level if the source and the target table are created correctly. Then using INSERT stmt , try to insert a record in Oracle databa...

Answer Question  Select Best Answer

Milind Jadhav

• Mar 21st, 2015

Informatica follow input variable n output process.thus you can make some calculations in variable port n copy them to the output port to achieve some purpose mostly used in expression tf

Kameshwara

• Aug 8th, 2013

variable ports are used in transformations like Expression/Aggregator where you can hold a value of incoming data. This can be helpful when you want to check if incoming column value is same or a cha...

Answer Question  Select Best Answer

Source:
col2 col1
a 1
b 1
c 1
d 1
p 2
q 2
r 2
x 3

how to do this...
thanks
krishna

Manjunath

• Apr 9th, 2015

Converting rows into columns is de-normalizing, you may have to use aggregate transformation to do so. Note: vice verse is normalizing the data, that can be done using normalizer transformation. U...

Shiva

• Jan 14th, 2015

Pivoting means converting rows to column and vise verse.

Please use normalization transformation to achieve this.

Answer Question  Select Best Answer

What is Dimensional modelling ? What is the difference between Data modelling and Dimensional modelling and Erwin modelling.

Manjunath

• Apr 9th, 2015

both Dim Modeling and ER modeling can be 3NF, which is highly normalized, As raj mentioned ER is used for OLTP and DM for OLAP. in both the cases data is stored in a set of tables and related to each ...

Sharat

• Jan 5th, 2015

Raj, 1NF is highly denormalized and the higher forms are more normalized. You said Dimensional Modeling is for datawarehouses and uses 3NF. Contains denormalized data. 3NF is highly normalized and how can the datawarehouses can have denormalized data

Answer Question  Select Best Answer

In SCD Type2 scenario, Informatica has no control on the DML operation.
How will we make sure that updates happen before Inserts in SCD Type2 dimension so that we can avoid the AK constraint error.

Abhilash tyagi

 Profile Answers by Abhilash tyagi Questions by Abhilash tyagi

• Jun 6th, 2015

You can try to change the name of the target instances. For example, let us consider we have 2 instances of targets CUST_D (insert) and CUST_D1 (update), try to change the name of insert instance to C...

Answer Question  Select Best Answer

( cross platform integration) - I am new to informatica n SAP , i got assignment work on integration of informatica and SAP R/3 , i need to import data from SAP , i went to could of videos on YouTube provided by Informatica Support , they are saying you need to install RFC libraries that are available on SAP market place, RFC libraries are platform specific , i do have SAP system on Unix and informatica...

prashanth naik

• Jul 7th, 2015

You can do it by configuring the Application connection, the connection will generate the ABAP code which hits SAP R/3 system and does data extraction.

Answer Question  Select Best Answer

how to join the data of two tables which do not have common columni mean how to perform non equi join in informaticaEg:just like getting data from emp and salgrade table of oracle where sal is between losal and hisalthanksvenu

milind

• Aug 6th, 2015

Yes dummy column will work
other way is to use mapping variable :)

ashish

• Sep 27th, 2014

You can create a dummy port in each source and assign 1 to both port and drag the both sources in joiner tr and give join condition on dummy port, After that you can use filter condition on your location

Answer Question  Select Best Answer

How to load 10000 records into dynamically created 100 files and to load 100 records in each?

Snehasis

• Sep 12th, 2015

This can be done using TC transformation. In an expression before the TC, keep a counter which increments for each row passed. When the counter reaches 100, reset the counter to 0. In the expression...

Answer Question  Select Best Answer

sudeep

• Sep 18th, 2015

In general Fact table is normalized and Dimension table is denormalized. So that you will get all required information about the fact by joining the dimension in STAR schema. In some cases where dimensions are bulky then we we snowflake it and make it normailzed.

Niranjan

• Apr 23rd, 2015

Normalization is splitting 1 table to multiple tables to avoid insert/update and delete anomalies. They are done in OLTP systems. De-normalization is exact opposite of normalization, here multiple tab...

Answer Question  Select Best Answer

How to generate a star pattern using Informatica depending on the number of rows in the input file

Suppose there are 7 rows in the source file (any type of data), the target should have 7 rows of stars in the following pattern:-

*
***
*****
*******
*********
***********
*************

SUM

• Oct 8th, 2015

V_star=iif( v_vount < = 1,*,rpad(v_star,vcount,*))
v_count=v_count+2
O_STAR=V_STAR

Answer Question  Select Best Answer

Can any one explain where we use Unix shell Scripts in informatica? Provided with example if possible.Thanks.......Jc

sum

• Oct 8th, 2015

1] To archive file
2] To create parameter file dynamically at run time
3] To have control and audit for source file/tables
4] To purge old files from server

savaram5553

 Profile Answers by savaram5553 Questions by savaram5553

• May 28th, 2015

Hi Nithin will you help me with batch script to bounce the informatica and DAC services.

Answer Question  Select Best Answer

Suppose I have one source which is linked into 3 targets.When the workflow runs for the first time only the first target should be populated and the rest two(second and last) should not be populated.When the workflow runs for the second time only the second target should be populated and the rest two(first and last) should not be populated.When the workflow runs for the third time only the third target...

sum

• Oct 8th, 2015

Define one variable $$CNT in mapping and assign its initial value as 1 in parameter file Take an expression and do below coding count =$$CNT INC_COUNT=$$CNT+1 O_INC_CNT=SETVARIABLE($$CNT,INC_COUNT) Ad...

Rakesh

• Feb 9th, 2015

your above logic is perfect..but instead resting the variable at workflow level you can add these condition in first router group => MOD(o_Flag,3) = 1 2nd router group =>MOD(o_Flag,3) = 2 3rd router g...

Answer Question  Select Best Answer

Suppose you have 2000 records in one table and 12000 in another which one you will consider as master and detail?

Read Best Answer

Editorial / Best Answer

ghola  

 Profile Answers by ghola Questions by ghola

• Member Since Jul-2008 | Aug 15th, 2008

---

The joiner transformation compares each row of the master source against the detail source. Hence, fewer number of rows in master means fewer iterations of join comparison.

Secondly It is easier to cache the table with fewer number of rows.

Hence, using the table having the fewer number of rows as a master improves the performance.

Raju R

• Oct 27th, 2015

@ponnana: The performance of the joiner depends on the rows and not on the columns. Also you take up the condition which consists n number of columns. Based on the condition the rows are obtained. So We need not worry about the columns.

Rashmi

• Oct 18th, 2015

The join is happening based on some condition. Therefore match process depends on the condition columns only and not how many columns are present in total. The table you drag into joiner first is considered as Master.

Improve Answer