What is difference between Informatica 6.2 Workflow and
Informatica Workflow 7.1
Answers were Sorted based on User's Feedback
Answer / shiva
In informatica 6.2 union transformation is not pressent and
where as in informatica 7.1 union transformation is present
| Is This Answer Correct ? | 5 Yes | 1 No |
Answer / vani
New features in Informatica 7.1:
1)Union and custom transformations
2)Look up on flat files
| Is This Answer Correct ? | 2 Yes | 1 No |
Answer / sekhar
In Informatica 7.1 enhancements are
Flatfile lookup,dynamic lookup chache enhancements,Union
transformation.
When we use dynamic lookup cache, the powercenter
sercer can ignore some ports when it compares values in
lookup ports and inputs ports before it updates a row in
the cache.
| Is This Answer Correct ? | 1 Yes | 1 No |
Answer / surya
new features in informatica 7.1 was
1. union transformation is added
2. custom ,, ,,
3. we can take flat file as lookup table
4.pmcmd command
5. server grid
6. transaction controle transformation
7. file repository concept
8.test load
| Is This Answer Correct ? | 1 Yes | 1 No |
why we need informatica
suppose we have 1 to 10 records.In router transformation we had given two condition A>= 5 A<=5 then what will be the output?
i have f;latfile source. i have two targets t1,t2. i want to load the odd no.of records into t1 and even no.of recordds into t2. what is the procedure and whar t/r's are involved and what is the mapping flow
What is the expected value if the column in an aggregator transform is neither a group by nor an aggregate expression?
i have a source with 100 records.i have 2 targets.in the first target i want to load first 50 records & in the second target i want to load next 50(or remaining) records.
What is confirmed fact in dataware housing?
What is different between the data warehouse and data mart?
If the records doesnt satisfy the filter condition where will it go?
Does an informatica transformation support only aggregate expressions?
What is target designer and target load order?
Hi I have two sources like A, B. My source A contain 10000 million records from that i need 20 attributes. My source B has also same 10000 million records from that i need only 1 attribute. By using Joiner i have to load into target? Is there any issue regarding this? if issue is there how to tune this mapping in best way?
complex mapping ur project u r invlve can u explain and give real time example give me ?