How to create different types of slowly changing dimensions (SCD) in informatica using the mapping wizard?
No Answer is Posted For this Question
Be the First to Post Answer
I HAVE A SOURCE FILE CONTAINING 1|A,1|B,1|C,1|D,2|A,2|B,3|A,3|B AND IN TARGET I SHOULD GET LIKE 1|A+B+C+D 2|A+B 3|A+B WHICH TRANSFORMATION I SHOULD USE
What is primary and backup node?
If the source has duplicate records as id and name columns, values: 1 a, 1 b, 1 c, 2 a, 2 b,the target shd be loaded as 1 a+b+c or 1 a||b||c, what transformations shd be used for this?
performance wise which one is better in joiner and lookup transformation?why?explain clearly?
How many joins in Informatica
Where is the cache stored in informatica?
Which are the different editions of informatica powercenter that are available?
By using Filter Transformation,How to pass rows that does not satisfy the condition(discarded rows) to another target?
Enlist few areas or real-time situations where informatica is required.
I am getting five sources in a day and i donot know when i get them. i need to load data into the target and run the session. but here i can't keep the session in running or can't stop the session. plz help me
How you prepared reports for OLAP?
suppose i have source 101 a 101 b 101 c 101 d i want target like 101 abcd how will u achive this please give me the answer