Interested to Buy Any Domain ? << Click Here >> for more details...
Which type or t/s is used to convert rows into column &
column into rows
- 9 Answers
- 30017 Views
- Infosys, I also Faced
- E-Mail Answers
Answer Posted / mural
hi ramarao plz explain step by step
i am gettikng confusion
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
what is dynamic insert?
what is Forward,Reverse and Re_engineering?
What are snapshots?
What is virtual Data Warehousing?
what are the reports created in mm and sd side using sap bw in a project? name some of them and explain the requirement?
Assume u have a 24CPU machine with 24GB RAM, suggest how u would like to configure Informatica ,like number of concurrent sessions, RAM requirements etc,max partitions that u would permit per mapping.
where we cannot use sorter Transformation. if we use then we will not get correct data?
Can u access a repository created in previous version of Informatica?
How to delete data which is not in source table?
what happens if the info.server doesn't find the session parameter in the parameter file?
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?
two sources S1,S2 containing measures M1,M2,M3, 4 dimensions D1,D2,D3,D4, 1 Fact F1 containing measures M1,M2,M3 and surrogate keys K1,K2,K3,K4 (a) write a sql statement to populate Fact table F1 (b) Design a mapping in Informatica for loading of fact table F1.
Hi, can anyone plz share the project architecture for etl testing(banking domain) plz explain the architecture .
how do use session mapping parameters ?(in which transformation)
how would u estimate the size of Lookup transform data and index cache?
