Interested to Buy Any Domain ? << Click Here >> for more details...
without dynamic lookup transformation how to insert new
rows and update existing rows?
- 7 Answers
- 16648 Views
- Cap Gemini, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / jhansi
YES,we can insert new rows and updat existing row
By setting Session level properties
1.Session->properties->TreatSourceRowas Update
2.Session->mapping->target properties->select update else
insert
| Is This Answer Correct ? | 8 Yes | 1 No |
Answer / sujana
@above
then wat is the use of lukup..if v can load in dis way
| Is This Answer Correct ? | 5 Yes | 1 No |
Answer / vali
you can use source qualifier transformation to do this.
write join condition ...
the rest of the operation will be same
| Is This Answer Correct ? | 0 Yes | 0 No |
Answer / sarthak
with SCD Type-1...
it uses normal look-up (not the dynamic look-up)
| Is This Answer Correct ? | 0 Yes | 0 No |
Answer / sujit
by the use of update strategy T/R we can insert new row and
updae a existing row on the time of T/R
| Is This Answer Correct ? | 1 Yes | 1 No |
Answer / murali raju
Simple you can take one look up transformation give the
condition as empno=empno1(if it is primary key) and take
update strategy transformation just pass condition as
IIF(empno=empno1,dd_update,dd_insert). in this way we can
insert new records and update old records without keepimg
historical data.
| Is This Answer Correct ? | 0 Yes | 0 No |
Answer / bj
With out lookup and update st. transformation we can still
insert new and update data at session level.
in session at the time giving target table connect bottom u
find insert and update just check that box.
| Is This Answer Correct ? | 1 Yes | 2 No |
What is meant by a domain?
1)can anyone explain how to use Normalizer transformation for the following scenario Source table | Target Table | Std_name ENG MAT ART | Subject Ramesh Himesh Mahesh Ramesh 68 82 78 | ENG 68 73 81 Himesh 73 87 89 | MAT 82 87 79 Mahesh 81 79 64 | ART 78 89 64 | please explain what should be the normalizer column(s) The GCID column 2)Also please explain the Ni-or-1 rule.
5 Answers FCS, IBM, Satyam, TCS,
how to import multiple flat files in to single target where there is no common column in the flat files
What is rank transformation?
my source contain data like this cno cname sal 100 rama@gmail.com 1000 200 karuna@yahoo.com 2000 i want load my data to the target is cno cname sal 100 rama 1000 200 karuna 2000 plz send the answer
where does the default group roew in a router is stored what is the default size of memory in router
Why update strategy and union transformations are active?
By using joiner t/r we can join only 2 tables, SO if want join more than 2 flat files ,How can i join?
what are the best practices to extract data from flat file source which are bigger than 100 mb memory?
my source is like this id,name sal 10 abc 1000,10 pqr 2000, 10 xyz 3000 ,10 jkl 4000 and my requirement is like this 10 abc,pqr,xyz,jkl 2000 .... i have try for this by using expression transformatin its ok of the concatenation of second column but the thing is that on third column if u group by using agg t/r the last value will com i.e 4000 but i asked by a interviewer that i dont want the first or last column i want the middle column i.e 2000 .plz reply for the same
Hi, Can someone send me the DWH and Informatica FAQ's at priti.singh84@gmail.com Thanks in Advance, preeti
What is meant by incremental aggregation?
Teradata 
