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


Please Help Members By Posting Answers For Below Questions

Differences between version 7.x and 8.x.

1423


generate date / time dimension in informatica

728


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

1560


What is the different lookup cache(s)?

617


Explain sessions and how many types of sessions are there?

587






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?

5587


What the difference is between a database, a data warehouse and a data mart?

599


What is informatica powercenter repository?

718


How to elaborate tracing level?

689


Explain the shared cache and re-cache?

617


Slowly changing dimensions, types and where will you use them

1281


Which version configuration tool used in ur project?

2772


What does “tail –f” command do and what is its use as an Informatica admin.

635


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

1692


Explain the difference between a data warehouse and a data mart?

600