Which type or t/s is used to convert rows into column &
column into rows
Answer Posted / kumar
i think we have to use macro function in build stage so we
have to write logic in macros but m not sure
| Is This Answer Correct ? | 1 Yes | 5 No |
Post New Answer View All Answers
1)Power center server and client on the same machine 2)power center server and client on the different machines What is the basic difference in these two setups and which is recommended ?
What is data modeling and data mining?
Can we create Hierarchies in generic datasources?
Difference between flat files and relational sources?
A mapping contains source table S_Time(stat_year,end_year) target table TIM_DIM(date,day,month,year,quarter) stored procedure transformation: A procedure has two parameters I_end_year and output parameter as O_date ,day , month, year, quarter, If this session is running, how many rows will be available in the target and why?
What do you understand by the term ‘transformation’?
How to delete data which is not in source table?
what are the production issues in datastage?
what is Forward,Reverse and Re_engineering?
SCD2 will work on only dimension tables as well as fact Table?
Explain and compare etl & manual development?
What are the various tools used in etl?
what is pmrep command?
what is a worklet?
how do u estimate the depth of the session scheduling queue? Where do u set the number of maximum concurrent sessions that Informatica can run at a given time?