what is session partitioning?
There are four Types of Session Partitioning Are there
1)Pass Through(Default)
2)Key Range
3)Round Robin
4)Hash Partition
| Is This Answer Correct ? | 0 Yes | 0 No |
1. if lookup tr is giving poor performamence. what u do. 2. i have emp,dept table. i want output ename,empno,dname,max(sal). 3. can any one tell me project flow in real time scenario. please send me mail any queries and answers my mail id is yaparala@gmail.com
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 are the concerns of OLTP and DSS systems?
What is cube grouping?
what is meant by drill through?(Mascot)
What is etl tool in hadoop?
how can i text accracy of ETL migration? i am very new to data warehousing. we are writing ETL scripts using SCRIPELLA tool. how can i test the correctness of data. and we are generating reports using pentaho . is there any easy way to test the pentaho. how can test these ETL scripts written in scriptella? thanks in advance
where is the cache (lookup, index) created and how can you see it.
what is session partitioning?
indatastage 8.1 surrgoate key generates seqences numbers write but there is limite value i want to reset the seqence after gettting some highest value like i want o/p like this 1 2 3 4 5 .............10000 1 2 3.........10000
If you concatenate data from a normalizer transformation,the ports you concatenate cannot include OCCURS(T/F).
Informatica server and client are in different machines. You run the session from the server manager by specifying the source and target databases. It displays error . You are confident that everything is correct. Then why it is displaying the error?