In a scenario I have col1, col2, col3, under that 1,x,y, and
2,a,b and I want in this form col1, col2 and 1,x and 1,y and
2,a and 2,b, what is the procedure?

Answer Posted / roopanwita

There is a stage in Datastage,Pivot to do normalization.

Is This Answer Correct ?    0 Yes 2 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Explain how many types of dimensions are available in informatica?

602


What if the source is a flat-file?

602


Describe an informatica powercenter?

621


What is the benefit of session partitioning?

610


Reusable transformation and shortcut differences

1392






Explain sql transformation in script mode examples in informatica

612


Why do you use Mapping Parameter and mapping variable?

1298


What is a mapplet/worklet in informatica?

697


Plz can any one say me how to get the informatica certification materials and dumps

1606


In which transformation you cannot drag ports into it?

801


Explain the mapping variable usage example in informatica

646


What is domain in terms of informatica?

574


What is repository manager?

544


What are active transformations.

1197


Explain the difference between mapping parameter and mapping variable?

612