What is the method of seperating unique and duplicate
records in session level?
Answer Posted / jz
Select Distinct Box at Source propeties level or jus
override sql in Session.
| Is This Answer Correct ? | 17 Yes | 3 No |
Post New Answer View All Answers
What are the settings that you use to configure the joiner transformation?
What are the different types of olap? Give an example?
Which is the t/r that builts only single cache memory?
What happen when you enable grid option avilable at session level ? (Ans found: Scalabily . A single session Parallelization) But how can one session is sharable among different nodes at the same time while running ?
Implementation methodology
Slowly changing dimensions, types and where will you use them
According to his methodology what all you need before you build a datawarehouse
Explain what are the different types of transformation available in informatica.
Is there any target staging area in informatica not staging area
Why do you use Mapping Parameter and mapping variable?
Can any one give me a real time example for FACT TABLE & DIMENSIONAL TABLE?
I have a mapping loading 100 records and it failed on 20th record. how to recover it without changing anything.(in prod where we don't have any access).. (the session should should start from 21 record)
I have a flat file, want to reverse the contents of the flat file
can we override a native sql query within informatica? Where do we do it? How do we do it?
How to use pmcmd utility command?