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 |
What is partioning?how many types of partinings are there
source : col1 101 101 101 102 102 102 103 103 103 col2 1000 1500 2000 1200 2300 3000 2400 1300 2000 i need target as col1 101 102 103 col2 1000,1500,2000 1200,2300,3000 2400 1300 2000
I have 1200 records how can u send it in aggregator with good performance issues?
How many transformations can be used in mapplets.
how the server recognises , if the session fails after loading the 100 records in to the target
checkout and checkin in informatica 8.6
Whats the difference between $, $$, $$$
How to join a Flat and Relational Source without using (Joiner, Update and Lookup ) transformations... is it possible? if yes i would like to know how?
how to through logic of informatica using the push down optimization into oracle.
1:when we develop a project what are the performance issue will raise?? KPIT 2:if a table have INDEX and CONSTRAINT why it raise the performance issue bcoz when we drop the index and disable the constraint it performed better??KPIT 3:what are unix commands frequently used in informatica??
what is surrogatekey ? In ur project in which situation u has used ? explain with example ?
write sql query to remove null value following table id name 101 dinesh null jyothi null bharathi 102 suresh null shilpha 103 prakesh null suma i want the output id name 101 dinesh 102 suresh 103 prakesh