Interested to Buy Any Domain ? << Click Here >> for more details...
we have three columns and two rows.
col1 col2 col3
a b c
want to change into 2 columns and 3 rows ,how?
col1 a
col2 b
col3 c
which transformation u'll use and how?
- 3 Answers
- 9392 Views
- Cognizant, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / sbvprasad
by using normalizer T/r u can do the above logic
| Is This Answer Correct ? | 8 Yes | 0 No |
Answer / abhishek kumar(abhisheklalmca@
src->sq->normalizer->expression->target
In normalizer--
c1(column name)- 3(occurs)-string(datatype)
In Expression--
o_c1 -(output port)
decode(GCID_c1,1,'col1',2,'col2',3,'col3')
connect
o_c1(expression) to c1( target port)
c1(exp) to c2(target) port
target should be like this
C1 C2
---------- -----
col1 a
col2 b
col3 c
thanks
abhishek
| Is This Answer Correct ? | 6 Yes | 0 No |
How do you take care of security using a repository manager
Explain the etl program with few examples.
Write the different tools in the workflow manager?
I have 4 columns in a table say, name ,address, salary and city. So based on distinct city names, i need to combine the other data and send it to a flat file. Distinct city names can be 4 or 5 or 6. So it has to dynamically generate flat files(4 or 5 or 6) corresponding to the city names.
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
How i can Schdule the Informatica job in "Unix Corn Schduling tool" ?
What happens if the info. Server doesn't find the session parameter in the parameter file?
What are the types of error logs available in Informatica?
How will you display "Mr" for male & "Mrs" for female in target table?
How to use Normalizer transformation?
Can we combine a flatfile and a database table using an UNION transformation?
explain different types of modeling.
Teradata 
