what are the enhancements made to Informatica 7.1.1 version
when compared to 6.2.2 version?
Answer Posted / shashiall
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
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 ? | 1 Yes | 0 No |
Post New Answer View All Answers
What is the main purpose of Unconnected lookup other than updating slowly changing dimensions? or In which case u use Unconnected lookup?
What are ETL Tools?
Can we change Dynamic to Static or Persistent cache? If so what happens?
Explain the types of transformations?
What are the new features of Power Center 5.0?
can any one explain about dataflow in the informatica project for bank domain....thanks is advance
Differentiate between joiner and lookup transformation?
What are the main issues while working with flat files as source and as targets ?
What happen when you enable grid option avilable at session level ? (Ans found: Scalabily . A single session Parallelization) But how can one session is sharable among different nodes at the same time while running ?
If I have 10 flat files with same name abc.txt files with different timestamps as source I need to load them in tgt table oracle. in between job execution fails and rows are not loaded into tgt. how can I make them load in that target even if my job fails?
If i have source as flat file. how can i store the header and trilor into one target and data into one more target. |------>target1(header+trailor) source------ |------>target2(data) can any one please help me
In how many ways we can create ports?
What is update strategy transform?
Differentiate between sessions and batches?
Explain the informatica workflow?