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


Please Help Members By Posting Answers For Below Questions

Hi, I want to do Informatica Designer certification. Can anyone help me by providing the details on this. Thanks in advance. Regards, Arnab

1629


What do you understand by a term domain?

648


How can repository reports be accessed without sql or other transformations?

701


What is sorter transformation?

556


What do you mean by worklet?

602






Is it possible to revert a global repository to local one and why?

591


How do you load unique records into one target table and duplicate records into a different target table?

679


explain about unit testing? in real time?

1631


Differentiate between sessions and batches?

545


When do you use sql override in a lookup transformation?

560


what is SDLC way of code development?

1536


What are Dimensional table?

585


What is a joiner transformation?

525


How do you load only null records into target?

715


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

1625