supose if ur scr table contains alphanumeric values like
1,2,3,a,v,c in one columen like c1 n now u have load d data
in 2 seperare columns like ID should contain only numbers
1,2,3 n NAME col should contain a,b,cin target?How
Answer Posted / rajesh bathini
seq---> Transformer------>
in transformer take one stageVariable
stg==> Alpha(C1) after transformer take two outputlinks
take constrain stg=0 for one link (number will go that link)
otherwise for one link(alphabets will go that link)
Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
Hi, I want to do Informatica Designer certification. Can anyone help me by providing the details on this. Thanks in advance. Regards, Arnab
What do you understand by a term domain?
How can repository reports be accessed without sql or other transformations?
What is sorter transformation?
What do you mean by worklet?
Is it possible to revert a global repository to local one and why?
How do you load unique records into one target table and duplicate records into a different target table?
explain about unit testing? in real time?
Differentiate between sessions and batches?
When do you use sql override in a lookup transformation?
what is SDLC way of code development?
What are Dimensional table?
What is a joiner transformation?
How do you load only null records into target?
in staging we are merging the data and remove the inconsistants data that type of situation what u will done and type of functions u can use