1. Categories >> Software >> Data Warehouse >> Informatica
  2. Suggest New Category

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

Question Posted / kishoreravi.c

No Answer is Posted For this Question
Be the First to Post Answer

Post New Answer

More Informatica Interview Questions

What is tracing level and what are the types of tracing level?

2 Answers   TCS,

How many ways are there to create ports?

0 Answers   Informatica,

What if i will group by with some port in aggregator and will not pass the sorted values. Will the session fails tell in both cases ( if i have configured it for sorted input and if i have not configured it for sorted input).

1 Answers   CTS,

Why do we use DSS database for OLAP tools?

2 Answers  

How an expression transformation differs from aggregator transformation?

0 Answers  




when i was running the seesion, after loading 100 records, session suddenly fails.Next time i want to load the remaing rows in target with out truncate target table.What should i use?

7 Answers   Cegedim, IBM, TCS,

 Code page compatibly –Where all changes are made to handle the scenario.

1 Answers   DELL,

How we can use union transformation?

0 Answers  

source : xml file target: xml file how can we check data loaded into target xml file using writing sql query. pls help on this asap.

0 Answers   Cap Gemini, Cognizant,

what is incremental loading ?

12 Answers   CTS, IBM, Oracle, TCS,

sample mappings for scd1,scd2 and scd3

2 Answers   Cognizant,

Can i create a lookup table without cache.

7 Answers   iGate,

For more Informatica Interview Questions Click Here
Categories