Question { 14040 }

what is lookup ?

Answer

in before informatica powercenter 9 version lookup it is works passive tranformation ,after that 9X lookup works both passive and active ,
informatica provide aditional features, at the time of lookup creation (multi match) check bok option is there , when you check multi match its works active.
genraly we can get source table,target tables,flatfiles al lthous thinks and compare hetroginious sources using lookup.
lookup participate each SCD mappig flow.

Question { IBM, 18580 }

what is the architecture of any Data warehousing project?

Answer

first we integrate data into source to staging tables, from staging we movie into work table at the data moment of stage to work we do all transformation logic , then from work table we load data into fact and dimention table using scd 2.

Question { TCS, 7926 }

if the column name in sql override is diff from the column name in source qualifier,what is the impact?

Answer

We can write any order under SQL query like Oracle SQL part , but the main thing is we need to maintain that query order in our all mapping flow. Else it's error

Question { TCS, 6266 }

Source-1
No name
1 satish
2 karthik
3 swathi
4 keerthi

Source-2
No name
1 satish
2 karthik
5 santhose
6 vasu


Target


3 swathi
4 keerthi
5 santhose
6 vasu here i want non matching
Records i want how to achieve that

Answer

Create union tr , send all ports from two sources ,create sorter tr after union sort port asc in column no.
And send this ports into new exp tr here create 3 variable port one output port.
V_curr_no=id------>no.
V_count=iif(v_curr_no=v_pre_no,v_count+1,1)
V_pre_no=I'd
O_count=v_count
After done exp tr
Pass all ports from exp to filter
Condition like o_count=1
Get all non_match records .then pass into tgt .

Happy thank yoy