can v update d records in target using update stargey
without generationg primary key ? explain
Answer Posted / sreekanth
@nagaraju
above answer is perfect.
we can mark as PK in etl level even though field is not
a PK in DB level
Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
Differences between version 7.x and 8.x.
generate date / time dimension 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
What is the different lookup cache(s)?
Explain sessions and how many types of sessions are there?
My source is delimited flat file Flat file data is H|Date D1|ravi|bangalore D2|raju|pune T|4 The data will be send to target if the fallowing two conditions satisfied 1.The first row Date column is equal to SYSDATE 2.Last record second port equal to number of records. How to achieve?
What the difference is between a database, a data warehouse and a data mart?
What is informatica powercenter repository?
How to elaborate tracing level?
Explain the shared cache and re-cache?
Slowly changing dimensions, types and where will you use them
Which version configuration tool used in ur project?
What does “tail –f” command do and what is its use as an Informatica admin.
SOURCE DATA IS DISPLAY IN THIS FORMATE IN TARGET . WHAT BUSINESS LOGIC WE CAN APPLY. source table target table ------------ ------------ c1 c2 c3 c1 c2 c3 -- -- -- -- -- -- 1 A J 1 2 B K 2 A 3 C L 3 B J 4 D M 4 C K 5 E N 5 E L F M N
Explain the difference between a data warehouse and a data mart?