Interested to Buy Any Domain ? << Click Here >> for more details...
hw to load this give the mapping?
cty state o/p
c1 s1 c1
c1 s2 s1
c1 s1 c1
c2 s3 s2
c3 s4 c1
c3 s2 s1
c2
s3
c3
s4
c3
s2
2 columns should be loaded to one column in target table?
- 1 Answers
- 7471 Views
- Wipro, I also Faced
- E-Mail Answers
Answer Posted / balaramesh
first create one normalizer transformation ,double click on
it ,select normalizer tab create column(column name is
cityandstate).set 2 in occurs field and datatype is
string ,next click ok. then automaticaly two input ports
(cityandstate,cityandstate)and threee out pouts
(cityandstate,gk_cityandstate,gcid_cityandstate) are
created.then set city is one inputport(cityandstate) and
state is another input port(cityandstate).set citystate
(outputport) to target table.
| Is This Answer Correct ? | 5 Yes | 0 No |
Post New Answer View All Answers
Differences between version 7.x and 8.x.
explain any diffcult scenario that u have faced in your experience... or explain any complex maping u have developed?
Why update strategy and union transformations are active? Explain with examples.
What are the tasks that can be performed using sq?
How can you differentiate between powercenter and power map?
Explain why we use partitioning the session in informatica?
Explain about Informatica server process that how it works relates to mapping variables?
How can we delete duplicate rows from flat files?
Explain pushdown optimization and types in informatica
My source is delimited flat file Flat file data is H|Date D1|ravi|bangalore D2|raju|pune T|4 The data will be send to target if the fallowing two conditions satisfied 1.The first row Date column is equal to SYSDATE 2.Last record second port equal to number of records. How to achieve?
SOURCE DATA IS DISPLAY IN THIS FORMATE IN TARGET . WHAT BUSINESS LOGIC WE CAN APPLY. source table target table ------------ ------------ c1 c2 c3 c1 c2 c3 -- -- -- -- -- -- 1 A J 1 2 B K 2 A 3 C L 3 B J 4 D M 4 C K 5 E N 5 E L F M N
What are the challenges you have faced in your Project (DWH- ETL)? Explain with example?
What is workflow manager?
What are the limitations of joiner transformation?
What are the popular informatica products?
