Interested to Buy Any Domain ? << Click Here >> for more details...
What are differences between Informatica 7.1 and 6.1
- 3 Answers
- 10757 Views
- I also Faced
- E-Mail Answers
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 is up date strategy and what are the options for update strategy?
What is hash partition?
Explain target update override in informatica
in my source i have 100 records, and 3 targets, i want to load 1st record into 1st target,2nd record into 2nd target,3rd record into 3rd target again 4th target into 1st target and vice versa,how to achieve this?
How do you migrate data from one environment to another?
3,if our source containing 1 terabyte data so while loading data into target what are the thing we keep in mind?
How do you avoid duplicate records with out using source qualifier,expression,aggrigator,sorter and lookup transformations ?
how can u generate sequence of values in which target has more than 2billion of records.(but with sequence generator u can generate upto 2 biliion only)
We can't use sql override or other properties when using Flat file as source. Then what is the use of Source Qualifier transformation?
Explain what are the different types of transformation available in informatica.
two tables from two different databases r there . both having same structure but different data . how to compare these two tables ?
How to load the data from a flat file into the target where the source flat file name changes daily?
Teradata 
