what are the enhancements made to Informatica 7.1.1 version
when compared to 6.2.2 version?
Answer / shashiall
lookup on flat file in informatica7.1
no such provision in 6.1
union all trnasformation in 7.1 not in 6.1
transaction control tranformation not in 6.1
file reposioty in 7.1
Except to previous points.........
1. PMCMD: By using this option we can use parameter file at
command prompt. Why this needed suppose we are using more
than on parameter file, in such case we have to change the
parameter file in session properties. By this option u can
run from command prompt by changing parameter file, no need
to go to session properties.
2. Test load: we can test the load by taking the specified
no. of records.
| Is This Answer Correct ? | 1 Yes | 0 No |
Define the various join types of joiner transformation?
Hi experts ,I have a Source of 1000 records.I have to load 100 records in first target,101 to 200 records in 2nd target, 201 to 300 records in 3rd target and again 301 to 400 in first target like that as cyclick process. How can i acheive this.
What is aggregate awareness?
In joiner, how to load Master table in Target?
What is a snowflake schema?
what is the logic will you implement to laod the data in to one factv from 'n' number of dimension?
What is Target Update Override? What is the Use ?
when informatica 8 series released ?
i have a table like empid ename year month sal 1 x 98 jan 500 1 x 98 feb 500 1 x 98 mar 500 1 x 99 jan 600 1 x 99 feb 600 2 y 98 jan 600 2 y 98 feb 600 2 y 98 mar 600 2 y 99 jan 700 2 y 99 jan 700 and so on i want to find out totsal for every emp on year wise plz help me
I have 1200 records how can u send it in aggregator with good performance issues?
What is a grid in Informatica?
how you will maintain version?