Interested to Buy Any Domain ? << Click Here >> for more details...
To achieve the session partition what r the necessary tasks
u have to do?
- 1 Answers
- 6861 Views
- I also Faced
- E-Mail Answers
Answer / swetha
Configure the session to partition source data.
Install the informatica server on a machine with multiple CPU's.
| Is This Answer Correct ? | 1 Yes | 2 No |
Suppose i have 10000 records.First time i have to load 1 to 1000 records and second run i have load 1000 to 2000 records and third load i have to load 2000 to 3000 rows .How will achieve
Is scd logic we have lookup right to compare the values with source and target,instead of lookup can u have any transformation or any way to do this?
how can i invoke pmcmd in command line prompt
What are limitations of joiner transformation?
what are 3 tech challenges/ common issues you face?
Source as 1 1 2 2 3 3 How to get target as 1 2 3 and 1 2 3
Can we combine a flatfile and a database table using an UNION transformation?
Suppose we have a (assume relational) source table Product_Id Month Sales 1 Jan x 1 Feb x . . . . . . 1 Dec x 2 Jan x 2 Feb x . . . . . . 2 Dec x 3 Jan x 3 Feb x . . . . . . 3 Dec x . . . . . . and so on. Assume that there could be any number of product keys and for each product key the sales figures (denoted by 'x' are stored for each of the 12 months from Jan to Dec). So we want the result in the target table in the following form. Product_id Jan Feb March.. Dec 1 x x x x 2 x x x x 3 x x x x . . So how will you design the ETL mapping for this case , explain in temrs of transformations.
without table how to come first record only in oracle?
there is a product table prodid prodname price 100 cinthol 10 101 hamam 10 102 neem 20 103 cake 30 in the above table the price of some products are duplicated and some product prices are distinct we want to push the duplicated prices to one target and non-duplicated prices to other target without using expression and sequence generator transformation
What does cheating measurement mean?
In dept 10, 5 emp sal, i want to do sum of dept 10 emp sal. Is there any othere transformation than the aggrator? if yes how?
Teradata 
