Interested to Buy Any Domain ? << Click Here >> for more details...
Can we insert ,update ,delete in target tables with one
update strategy tran.?
- 2 Answers
- 11545 Views
- Zensar, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / manojkumar
Yes we can do all these insert,update,delete also reject by
using single update strategy.
In update strategy write the code like this
iif(somexvalue=xx,dd_insert,iif(somexvalue=yy,dd_update,iif
(somexvalue=zz,dd_delete,dd_reject)))
| Is This Answer Correct ? | 12 Yes | 2 No |
Suppose we have a csv file with contents as below which is used has a source file. C1,C2,C3,C4 100,200,A B,300 200,400,X,Y,299 ---> it should be 4 values but by mistake 300,600,C D,566 with a comma in between X & Y,its 5. My target takes only 4 columns, How to take care of the 2 record as above without rejecting it and loading in the target. Hope u guys have understood my scenerio
1)What is Data Masking in informatica? 2)How to restrict junk characters while loading data into target. 3) what happen if i won't pass sorted input in a transformation.
Explain how many types of dimensions are available in informatica?
how to run 2 workflows sequentially. plz respond what is the process?
Performance tuning in UNIX for informatica mappings?
What if i will group by with some port in aggregator and will not pass the sorted values. Will the session fails tell in both cases ( if i have configured it for sorted input and if i have not configured it for sorted input).
Hi, I am new to Informatica, What is a flat file and how to use flat file in infomratica please help me.
How can you recognise whether or not the newly added rows in the source r gets insert in the target ?
when will we use unconnected & connected lookup? How it will effect on the performance of mapping?
why u go for dimensions ?
How do you create single lookup transformation using multiple tables?
Can you please mail me a copy of Informatica Certification Exam dumps to r_balakrishna@yahoo.com
Teradata 
