While using update strategy in the mapping which gives more performance, a fla

While using update strategy in the mapping which gives more
performance, a flat file or Table? Why? What are the
advantages and disadvantages?

Question Posted / sujith

4 Answers
8872 Views
I also Faced
E-Mail Answers

Answers were Sorted based on User's Feedback

While using update strategy in the mapping which gives more performance, a flat file or Table? Why..

Answer / kish`

hi,

update strategy never use for flatfiles....plz correct me,
if it is wrong

Is This Answer Correct ?

14 Yes

1 No

While using update strategy in the mapping which gives more performance, a flat file or Table? Why..

Answer / krish

yes ur rt man
hay kish can i have ur mail id

Is This Answer Correct ?

0 Yes

0 No

While using update strategy in the mapping which gives more performance, a flat file or Table? Why..

Answer / sanjay

You are write Krish.. we can not use update stratety in flat
files...

Can I have ur mail id plz?.. my email id is
sanjaygupta1981@gmail.com

Is This Answer Correct ?

0 Yes

0 No

While using update strategy in the mapping which gives more performance, a flat file or Table? Why..

Answer / krish

flat file
bcz no connections needed no network busy etc;

Is This Answer Correct ?

0 Yes

5 No

Post New Answer

More Informatica Interview Questions

I have in my source Records like 100,101,102 etc. I have router transformation which has groups like one group is empno=100, second group is empno>99. Now i want to know my source record 100 loads into which group?

5 Answers Span Systems,

Filter transformation in the condition one of the data is NULL would the record be dropped.

2 Answers

How to display null values on a target & non-null values on a target?

3 Answers

i have 1000 records in my dource table, the same i have in target ,but a new column added in target as "batchno", and this column adds no 10 for 1st 100 records and 20 for next 100 records and 30 next 100 records and vice versa. how to acheive this?

6 Answers Thomson Reuters,

write a query to get maximum salary from the employers table without duplicates....kindly help me

5 Answers CTS,

how DTM buffer size and buffer block size are related

3 Answers Wipro,

Hi, I saw one mapping implemented by my seniors . In Expression transformation they implemented following logic. That is iif(is_date(in_UC_DATINV,'YYYYMMDD'),to_date(in_UC_DATINV,'Y YYYMMDD'),'Inventory Date is either invalid or null') Inventory_Date is validated only for is_date() But not validated for notisnull() . But error says “ either invalid or null “ why? Whether is_date() also check for not isnull() ? or in this logic something is different ? Please answer me . Advance thanks

0 Answers IBM,

what is worklet and what use of worklet and in which situation we can use it?

4 Answers Patni, TCS,

i have a source of n records.i have to load n+5 records to my target.What is the procedure??????plz tell me.....

1 Answers

what is constraint based load order

2 Answers Cap Gemini,

What is deployment group?

0 Answers

can we use cartesian join in informatica

3 Answers IBM,

For more Informatica Interview Questions Click Here