What are differences between Informatica 7.1 and 6.1
Answers were Sorted based on User's Feedback
Answer / rishikesh
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
| Is This Answer Correct ? | 0 Yes | 1 No |
Answer / sanjay
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 ? | 0 Yes | 1 No |
What do you mean by blocking transformation?
What are the new features in Informatica 5.0?
Could any one to tell Fact table Partitioning?
i have oracle table A and target B. i don't know how many records. i want get get last record in table A as first record in target table B. write a sql query?
source is a flat file empname, empno, sal ram, 101, 1,000 sam, 102, 2,000 ques: my target needs the data to be loaded as sal -1000 and 2000 excluding commas target empname, empno, sal ram, 101, 1000 sam, 102, 2000 how to implement this?
How to update a particular record in target with out running whole workflow?
In real time scenario where can we use mapping parameters and variables?
Explain how many types of dimensions are available in informatica?
State the limitations where we cannot use joiner in the mapping pipeline?
What is difference between maplet and reusable transformation?
Can you generate reports in Informatcia?
Explain constraint based loading in informatica