Interested to Buy Any Domain ? << Click Here >> for more details...
i have source like
X1 10
X2 20
X1 30
X2 40
i want target as
X1 X2
10 20
30 40 in informatica
- 2 Answers
- 8295 Views
- HP, I also Faced
- E-Mail Answers
Answer Posted / raji
Well,As of my knowledge.....
first u have to take eliminet the duplicates.....like
SRC---->SQ--->AGG---->TGT
in aggr t/f give the group by for both ports...
after this step just use a normalizer t/f to convert these
rows in to columns...
| Is This Answer Correct ? | 2 Yes | 0 No |
Post New Answer View All Answers
Under which circumstances, informatica server creates reject files?
Performance tuning( what you did in performance tuning)
What are Dimensional table?
What is joiner transformation in informatica?
What is sq transformation?
Difference between Target-based loading and constraint-based loading?
whats the logic to load the lower level of granularity of data to fact table.
In how many ways we can create ports?
r u done any partitions in ur project?
tell me 5 session failure in real time how can you solve that in your project?
On which transformations you created partitions in your project?
How can we use mapping variables in informatica? Where do we use them?
how lookup transformation is made active in new versions... When to use connected and when to use unconnected lookup and why? which is good for session performance. How to make lookup persistent and how to remove stale data from that lookup. how commit works - when we stop or abort data. Explain in both cases. What is factless fact table and have you ever used it in real time scenarios.
What is informatica etl tool?
What do think which one is the better joiner or look up?
