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
What is a filter transformation and why it is an active one?
Whats the difference between informatica powercenter server, repositoryserver and repository?
If the source has duplicate records as id and name columns, values: 1 a, 1 b, 1 c, 2 a, 2 b, the target should be loaded as 1 a+b+c or 1 a||b||c, what transformations should be used for this?
Debugger what are the modules, what are the options you can specify when using debugger, can you change the expression condition dynamically when the debugger is running.
What is the command used to run a batch?
How many ways are there to do 'remove duplicate records in informatica'?
What is dimensional table?
What are data-driven sessions?
draw informatica architecture 8.6 ?
Explain the difference between a data warehouse and a data mart?
Explain sql transformation in script mode examples in informatica
How do you manage the Parameter files while migrating your data from one environment to another environment?
I have done MBA in 2008. i got job as business analyst in 2008 january through consultany. but after 3 months they are giving training Informatica developer. now iam continuing this job. my question is when iam going to interview HR people ask me many times like this " YOU ARE MBA GRADUATE. HOW YOU ARE SELECT THIS POSTION. IAM EXPLAINING WHAT I HAVE MENTION ABOVE". PLEASE TELL HOW IAM TELLING THIS QUESTION ANSWER.
How can we send the flat file data to different targets(which are also flat files) based on the name of flat file with out adding extra columns?
In informatica workflow manager, how many repositories can be created?