Interested to Buy Any Domain ? << Click Here >> for more details...
While using update strategy in the mapping which gives more
performance, a flat file or Table? Why? What are the
advantages and disadvantages?
- 4 Answers
- 9175 Views
- I also Faced
- E-Mail Answers
Answer Posted / krish
flat file
bcz no connections needed no network busy etc;
| Is This Answer Correct ? | 0 Yes | 5 No |
Post New Answer View All Answers
what is index?how it can work in informatica
How do you load unique records into one target table and duplicate records into a different target table?
How to extract sap data using informatica?
What is union transformation?
What is a sequence generator transformation?
write a query to retrieve the latest records from the table sorted by version(scd)
if i hv 6 table as source table but can i make 12 as a dim table and 6 as fact table belongs to that src table.
Explain the different lookup methods used in informatica?
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
Briefly explain your complete project(sales) flow, (ie. from source received from client, transformations, then despatch to end user) what are all the process. Kindly give step by step process.
What are the conditions needed to improve the performance of informatica aggregator transformation?
Hi, I want to change date type char value integer value? I tried alter table tab_name modify (newcolumn newdatetype). But The columns have 10 million values(char type) so I want to load now numeric data. How it is possible? Old Values New Value(I want to load numeric data but the old value should be there in the column) Y 1 N 0 ERROR at line 1: ORA-01439: column to be modified must be empty to change datatype Please help on this. Thanks, GM
What do you mean by DTM and Load manager and what is difference between load manager and load balancer?
To Provide Support For Mainframes Source Data, which Files Are Used As A Source Definitions?
Explain the informatica workflow?
