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
- 9399 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 |
Explain the informatica workflow?
What are your source in project and how you import in informatica? How can i explain abt this?
1 Answers Accenture, Unisoft Infotech,
Aggregator transformation is having fields say a,b,c,d,e group by is enabled on a,b,c with sorted input,How the aggregator transformation process the i/p data?or in which way i/p comes to agg transformation
Suppose we have a source qualifier transformation that populates two target tables. How do you ensure tgt2 is loaded after tgt1?
What is checksum termnology in informatica? Where do you use it ?
3 Answers Chase, Cognizant, Deloitte,
What is the need of etl tools?
source : col1 101 101 101 102 102 102 103 103 103 col2 1000 1500 2000 1200 2300 3000 2400 1300 2000 i need target as col1 101 102 103 col2 1000,1500,2000 1200,2300,3000 2400 1300 2000
what is workflow varible
My source data like... Empid Name 10 chandra 10 sekhar I am expecting result is Empid Ename 10 Chandrasekhar How can we solve this prob?
Define joiner transformation?
hi,this is satheesh working as pl/sql resource in MNC.i just wanna switch to informatica.Could you please let me know what is the best way to learn informatica.what are the best coaching centres available in chennai?Is there any coaching centre will give me a real time experience? informatica
Can any one give me a real time example for FACT TABLE & DIMENSIONAL TABLE?
Teradata 
