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
- 6690 Views
- Wipro, I also Faced
- E-Mail Answers
Answer / 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 |
What is status code in informatica?
Explain load alternative records / rows into multiple targets - informatica
There are n numbers of flatfile of exactly same format are placed in a folder .Can we load these flatfile's data one by one to a single relational table by a single session??
what we require for D.modelling?
why we are using surogate key in real time give me explanation
Write a query to display Which deptno is containing highest Sal > avg (sum (Sal)) of all deptno; Avg (sum (Sal)) o f all deptno= 9675 Deptno, sum (Sal) 10 8750 20 10875 30 9400
i have to extract data from a flat file.the flat file has 10 records.i have to extract the 1st and 5th record every time.how is it done.
what is pre and post sql and what is diff between source presql and target pre sql
what is the difference between static and dynamic
How to improve the session performance in informatica?
How to identify this row for insert and this row for update in dynamic lookup cache
how the server recognises , if the session fails after loading the 100 records in to the target
Teradata 
