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 |
There are two sessions are connected to the workflow. When the first session run load the data(employees data sum_salaries <= 1000000) into the target1. When the second session run load the data(employees data sum_salaries > 1000000) into the target2. How to achieve this?
replace multiple spaces with single space.
define galaxy repository in informatica
If in a workflow i have n number of sessions and each session is configured with different different stop on errors (say 5,8,10 etc respectively).How can make all this same for all the sessions with out actualy touching each and evry session ?
Explain the code page compatibility?
What is a sequence generator transformation?
SOURECE Name id dept sal 1 a1 A 100 2 b1 B 200 3 c1 C 300 4 d1 D 400 TARGET: Name id dept sal 1 a1 A 100 2 b1 B 200 3 WER1 567 300 4 d1 D 400 I HAVE SOURCE AND TARGET. HOW TO VALIDATE DATA? TELL ME 5 STEPS ABOVE TABLE?
How many dimensions are there in informatica?
Could any one to tell Fact table Partitioning?
what type of problem you faced insales project or insurance project
Load data to multiple targets according date. When First time session runs it should send to 1st target,second time session runs then send to 2nd target and goes on how to achieve it
how will u load the data to diminision tables and fact tables,what is the hiraraichy why we are using hirarichy