In update strategy target table or flat file which gives
more performance ? why?
Answer Posted / nagaraju
flat file is better than relational becoz there is no index concet in flat file
Is This Answer Correct ? | 1 Yes | 1 No |
Post New Answer View All Answers
What are pre and post-session shell commands?
COL1,COL2 ABC,1 XYZ,2 HERE IN COL2 VALUES 1,2 NOT STSANDARD(IE MEANS NOT FIXED VALUES LIKE OTHER SOME VALUES LIKE 10,20) O/P IS COL1,COL2 ABC,2 XYZ,1
what are all the deliverables of ETL informatica power center project? what are all updated or created by etl developer as his everyday activities?
How many transformations can be used in mapplets.
What is the difference between writing a joiner query in ANSI style and THETA style?
Can we use procedural logic inside infromatica? If yes how, if now how can we use external procedural logic in informatica?
Explain the different dimensions.
How to update a particular record in target with out running whole workflow?
Explain sessions?
What is a stored procedure transformation?
How can we send the flat file data to different targets(which are also flat files) based on the name of flat file with out adding extra columns?
Describe data concatenation?
What are the main features of Oracle 8i with context to datawarehouse?
What is substr in informatica?
can we override a native sql query within informatica? How do we do it?