followin source like

region sales
1 100
2 200
i want the output following format
region 1 2
sales 100 200

Answer Posted / lakshman

normalisation t/r

Is This Answer Correct ?    0 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What can we do to improve the performance of informatica aggregator transformation?

620


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?

5576


what are all the deliverables of ETL informatica power center project? what are all updated or created by etl developer as his everyday activities?

1776


What are pre and post-session shell commands?

739


can we override a native sql query within informatica? Where do we do it?

626






Hi all , I am planning for informatica S - PowerCenter 8 Mapping Design certification. I have rewuired the dumps for the same. if anyone of you having the same pl. share it with me. This will be of great help. My contact is : sagardev7@gmail.com TIA , Sagar

2282


In what scenario we use to improve session performance by pushdown optimization?can any one give example?

5255


what is the -ve test case in your project.

1854


What is intricate mapping?

592


How to extract the informatica rejected data?

755


I want my deployment group to refer an external configuration file, while i deploy in the production environment. How can i achieve it.

1582


How can informatica be used for an organization?

653


What are ETL Tools?

666


can anybody send me some real time screenshots of mapping in informatica powercenter. i will be vary thankful to him. my e-mail id :- prakashkumar.kumhar@gmail.com

4311


Explain the scenario which compels informatica server to reject files?

656