Interested to Buy Any Domain ? << Click Here >> for more details...
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
- 4 Answers
- 15057 Views
- TCS, Wipro, I also Faced
- E-Mail Answers
Answer Posted / sai krishna karri
Here you should not use a router as it sends the data to
two different target or two instances of the same target.
As the question here is to write the input row to to
different columns based on the value, you can just use an
expression, pass the column and create two output ports.
Output port 1 to detect if it is a numeric. And the second
output port to detect the alphabet.
output port 1 - op1
iif(is_numeric(to_int(c1)),c1)
output port 2 - op2
iif(is_alphabet(c1),c1)
Pass these two outputs to a filter and set ths condition
Not isnull(op1) or Not isnull(op2)
Link the columns to the target now. Done!
| Is This Answer Correct ? | 9 Yes | 6 No |
Post New Answer View All Answers
explain about unit testing? in real time?
server hot-ws270 is connect to Repository B. What does it mean?
What is the difference between power center and power mart? What is the procedure for creating independent data marts from informatica 7.1?
How is union transformation utilized?
Hi Everybody, I have one fixed width file as source and 4 oracle tables (relational) as target. What are the Unit test cases i need to implement ? 1.Using TextPad software i tested postion of the field 2.As per specification i tested like whether it is correctly mapped or not? Is there any other test case do i need to implement. If possible can any one give me the test cases Advance Thanks
How can you differentiate between powercenter and power map?
I want my deployment group to refer an external configuration file, while i deploy in the production environment. How can i achieve it.
What are the reusable transformations?
How can we send the flat file data to different targets(which are also flat files) based on the name of flat file with out adding extra columns?
1)you have multiple source system where u receive files ,how do you actually load into mapping using transformation,what are the transformation you use? 2)you have files in ftp location ,how do you get it into mapping with you ETL concept?
What is the difference between a connected look up and unconnected lookup?
Can we use procedural logic inside infromatica? If yes how, if now how can we use external procedural logic in informatica?
what are 3 tech challenges/ common issues you face?
What is the Process to creating lookup transformation in informatica
What is workflow? What are the components of workflow manager?
