Interested to Buy Any Domain ? << Click Here >> for more details...
how do u decide whether u need to do aggregations at
database level or at Informatica level?
- 1 Answers
- 4302 Views
- I also Faced
- E-Mail Answers
Answer / chintan thakkar
It should always be done at SQ level, that will improve the performance of the mapping since informatica stores a cache for aggregator transformation.
| Is This Answer Correct ? | 0 Yes | 0 No |
what are the data modeling tools you have used?(polaris)
if i have a query as flat file how can we load data to target table
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?
what is granularity in Data ware House?
In Which Transformation We Can Use Having Clause In Informatica?
CAN ANY ONE SEND ME THE CODE FOR THE BELOW 1).REMOVE '_' FROM TELE PHONE "323-237-2323" AND SHOULD DISPLAY OUT PUT AS "323237232" 2). NEED TO ONLY "COMPANY.COM" FROM EMAIL FILED "TEST@COMPANY.COM"
what is the difference between shortcut of an object and copy of an object? compare them?
how do u estimate the number of partitions that a mapping really requires? Is it dependent on the machine configuration?
Mention few test cases and explain them?
Do we need an ETL tool? When do we go for the tools in the market?
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 is the difference between project backlog and product backlog?
Teradata 
