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
- 7542 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
Explain how to import oracle sequence into informatica?
What is aggregate cache in aggregator transformation?
How does a rank transform differ from aggregator transform functions max and min?
Which means the first record should come as last record and last record should come as first record and load into the target file?
Explain what are the different types of transformation available in informatica.
What is workflow monitor?
What is target designer and target load order?
Parameter and variable differences
Calculate sum of salaries department wise. Then the sum will be repeat for all columns in each department. Develop a mapping for this.
What are the challenges you have faced in your Project (DWH- ETL)? Explain with example?
Explain joiner transformation in informatica
what is mean by complex business rule ?
How do you load more than 1 max sal in each department through informatica or write sql query in oracle?
generate date / time dimension in informatica
Explain the use of aggregator cache file?
