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 |
IN A MAPPING WHEN WE USE AGGRIGATER TRANSFORMATION WE WILL USE GROUP BY PORT. IF GROUPBY IS NOT SELECTED BY DEFAULT IT WILL TAKE ONLY THE LAST COLUMN WHY????
WHAT IS USE OF SQL OVERRIDE IN SOURCE QUALIFIER? chandumba2005@gmai.com
What is the difference between Active and Passive transformation?
Hi All can anyone tell me where i will get Informatica training in Mumbai?
Plz can anybody send Informatica and Cognos FAQ Plz To thid ID anil643@gmail.com (or) kumar643@gmail.com
Why do you use Mapping Parameter and mapping variable?
what are the settiings that u use to cofigure the joiner transformation?
If i done any modifications for my table in back end does it reflect in informatca warehouse or maping desginer or source analyzer?
TWO FLAT FILES ARE THERE , EACH HAVING NO MATCHING COLUMNS . HOW CAN U JOIN THESE TWO USING JOINER TRANSFORMATION ?
What if the source is a flat-file? Then how can we remove the duplicates from flat file source?
Hello , I am unable to work with SQL transformation at least. Where do i need to give connection for sql transformaton ? At session level there is no property . I have created a SQL Transformation and chosen query mode. But do i need to pass connection information to it ? I don't know where do i need to write a query ? I have written a query in file and that file path i gave in the properties of SQL Transformation. But it is not working. Could any one of you please let know how can i work with SQL Transformation? Advance Thanks.
Can you access a repository created in previous version of Informatica?