Session S1, S2, and S3. In the session S3 I want to load every
Saturday. How it is possible?
Answer Posted / anindita
I would change the link condition from S2 --> s3.
I'll format the Sysdate to return 'DAY' and then check if that is equal to Saturday, if that is true link condition is true else false.
| Is This Answer Correct ? | 3 Yes | 0 No |
Post New Answer View All Answers
What do you mean by blocking transformation?
What are the prerequisite tasks to achieve the session partition?
can any one give some examples for pre sql and post sql(Except dropping and creating index).
Hi, I want to change date type char value integer value? I tried alter table tab_name modify (newcolumn newdatetype). But The columns have 10 million values(char type) so I want to load now numeric data. How it is possible? Old Values New Value(I want to load numeric data but the old value should be there in the column) Y 1 N 0 ERROR at line 1: ORA-01439: column to be modified must be empty to change datatype Please help on this. Thanks, GM
IN SCD1, insource we have 10 billion records and in the first day its uploaded successfully and in the second day its taking time to upload because some records it might get update or insert new records. As a developer what will be the better solution for this??
complex mapping ur project u r invlve can u explain and give real time example give me ?
How can we improve session performance in aggregator transformation?
What is dimensional table?
What are pre and post-session shell commands?
Dimension Object created in Oracle can be imported in Designer Cubes contain measures
What is native users?
Explain the difference between a data warehouse and a data mart?
How do you load unique records into one target table and duplicate records into a different target table?
What is the need of etl tools?
What are the reusable transformations?