SOURCE DATA IS DISPLAY IN THIS FORMATE IN TARGET . WHAT
BUSINESS LOGIC WE CAN APPLY.
source table target table
------------ ------------
c1 c2 c3 c1 c2 c3
-- -- -- -- -- --
1 A J 1
2 B K 2 A
3 C L 3 B J
4 D M 4 C K
5 E N 5 E L
F M
N
No Answer is Posted For this Question
Be the First to Post Answer
how to insert header after each group.
Can any one give me a real time example for FACT TABLE & DIMENSIONAL TABLE?
How to delete duplicate records in a flat file source?
i have a table with name field. i,e name Shankar prabhakar nitikripa so no if a occures 3 times in name then it will go to tgt A if b occures 3 times in name then it will go to tgt b .. if z occures 3 times in name then it will go to tgt z
What are the different versions of informatica?
lookup is passive y can't it be active? let us say i have some records in my source like 101,rohit,1000 101,rohit,1000 102,kumar,2000 like wise now as it is having multiple matches i return only first,last value it can't return bouth the values that means lookup is acting as select distinct right by default what means it is active?
Without using Lookup & Sequence Generator, How to generate Sequence?
How do you convert single row from source into three rows into target?
What if the source is a flat-file?
What is the difference between a router and a filter transformation?
How do you use reject loader.
how to get the data from the client machine and how to get server location data to client loction can any one explain bit deep please..!