What are differences between Informatica 7.1 and 6.1
Answer Posted / raja
informatica difference
| Is This Answer Correct ? | 1 Yes | 1 No |
Post New Answer View All Answers
Why update strategy and union transformations are active? Explain with examples.
What is meant by active and passive transformation?
How do you remove duplicate records in informatica? And how many ways are there to do it?
Whats the difference between informatica powercenter server, repositoryserver and repository?
Explain joiner transformation in informatica
Explain scd type 3 through mapping.
Define sessions in informatica etl?
What is domain and gateway node?
During the running session, output files are created by informatica server. Enlist few of them.
what is granularity,what type of granularity we will take in fact tables either lowlevel or highlevel,if two tables having same granularity that is posiable or not
How do you load first and last records into target table? How many ways are there to do it? Explain through mapping flows.
How many ways are there to create ports?
Describe the impact of several join conditions and join order in a joiner transformation?
My source is delimited flat file Flat file data is H|Date D1|ravi|bangalore D2|raju|pune T|4 The data will be send to target if the fallowing two conditions satisfied 1.The first row Date column is equal to SYSDATE 2.Last record second port equal to number of records. How to achieve?
what are factless facts? And in which scenario will you use such kinds of fact tables.