Answer / bobby

I think in the session Properties, we can update or insert
the record with out using update strategy in the mapping.
I think it works. If i am wrong let me know

Answer / sweta kedia

In target,there is a update override option of updating the
records using the non-key columns. Using this one wecan
update the records without using update strategy t/r

Answer / g. manthiramoorthy

You can set the property at session level
"TREAT SOURCE ROWS AS: "Update"

Answer / prasad

In target

there is a update override option is there using this one we
can update the records without using update strategy t/r

Answer / ganesh

1) If the target table doesn't have primary key, then using
update override we can update the records.

2) If target table have primary key, then we have option
called update else insert in session properties. Based upon
that we will update the records.

Answer / har

i guess dynamic look up cache

Answer / shiv

you can set the property at session level TREAT SOURCE ROWS
AS 'DATA DRIVEN'. BECOUSE WE CAN SET UPDATE AT MAPPING
LEVEL AND SESSION LEVEL.

Answer / balaji

Hi,
Yes. Following above answers.,
We have to keep the checkmark for Update and also needs to
keep Load source as "Data Driven". Moreover, we need to also
take care that target updating table is getting updated
based on one or more Key value in it.

Thanks,
S Balaji.

Answer / sushma

you can use SQL transformation

Answer / radhakrishnansk

i guess procedural transformation.

How to load the data into target table, which not have Primary/Surrogate key (Duplicate records not acceptable)

5 Answers   TCS,

There are 2 files, Master and User. We need to compare 2 files and prepare a output log file which lists out missing Rolename for each UserName between Master and User file. Please find the sample data- MASTER.csv ---------- Org|Tmp_UsrID|ShortMark|Rolename ---|---------|----------|------------ AUS|0_ABC_PW |ABC PW |ABC Admin PW AUS|0_ABC_PW |ABC PW |MT Deny all GBR|0_EDT_SEC|CR Edit |Editor GBR|0_EDT_SEC|CR Edit |SEC MT103 GBR|0_EDT_SEC|CR Edit |AB User USER.csv -------- Org|UserName|ShortMark|Rolename ---|--------|---------|------------ AUS|charls |ABC PW |ABC Admin PW AUS|amudha |ABC PW |MT Deny all GBR|sandya |CR Edit |Editor GBR|sandya |CR Edit |SEC MT103 GBR|sandya |CR Edit |AB User GBR|sarkar |CR Edit |Editor GBR|sarkar |CR Edit |SEC MT103 Required Output file: --------------------- Org|Tmp_UsrID|UserName|Rolename |Code ---|---------|--------|------------|-------- AUS|0_ABC_PW |charls |ABC Admin PW|MATCH AUS|0_ABC_PW |charls |MT Deny all |MISSING AUS|0_ABC_PW |amudha |ABC Admin PW|MISSING AUS|0_ABC_PW |amudha |MT Deny all |MATCH GBR|0_EDT_SEC|sandya |Editor |MATCH GBR|0_EDT_SEC|sandya |SEC MT103 |MATCH GBR|0_EDT_SEC|sandya |AB User |MATCH GBR|0_EDT_SEC|sarkar |Editor |MATCH GBR|0_EDT_SEC|sarkar |SEC MT103 |MATCH GBR|0_EDT_SEC|sarkar |AB User |MISSING Both the files are mapped through Organization, Shor_mark. So, based on each Organization, Short_Mark, for each UserName from User.csv, we need to find the Matching and Missing Rolename. I am able to bring Matching records in the output. But really I don't find any concept or logic to achieve "MISSING" records which are present in Master and not in User.csv for each UserName. Please help out guys. Let me know if you need any more information. Note:- In User.csv file, there are n number of Organization, under which n number Shortmark comes which has n number of UserName.

0 Answers  

Whats the difference between $, $$, $$$

9 Answers  

Tell me about your experience in informatica? what is best mark you can give yourself? How to answer this question?

0 Answers   HCL,

What is joiner cache?

2 Answers   TCS,

Why do we use DSS database for OLAP tools?

2 Answers  

i have one table like cust_id ph1 ph2 ph3 1002 9290123526 97671927210 9876545232 we use Normalizer wt is o/p? sue normalizer we can generate three tables in single table/

4 Answers  

Can anyone briefly describe abt audit table loading?

2 Answers   TCS,

Define Update Override?

1 Answers  

When you move from devel to prod how will you retain a variable

1 Answers  

How can you recognise whether or not the newly added rows in the source r gets insert in the target ?

2 Answers  

Which transformation can be created only as reusable transformation but not as non-reusable transformation?

1 Answers   Informatica,