Interested to Buy Any Domain ? << Click Here >> for more details...
If source is having 5000 rows,and if you want to load data
into 500 rows to target,if the session runs successfully,how
can you verify the target if the rows are successfully
loaded or not.
- 3 Answers
- 8808 Views
- IBM, TCS, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / abhishek upadhyay
Through session log/run properties I can see how many rows
were inserted in the target table
| Is This Answer Correct ? | 15 Yes | 0 No |
Answer / raveendra g
By using Testload option, we can test the rows.
| Is This Answer Correct ? | 4 Yes | 1 No |
What are the various types of transformation?
What is meant by pre and post session shell command?
How to load last n records of file into target table - informatica
Scenario is like this: Name Sal A 10; B 20; C 30; Then Output should be Name Sal A 10; B 20; C 30; Total 60; Use SQL For this scenario
When do you use mapping parameters? (In which transformations)
Can we use parameters of parameter file in presession command
Can you use flat files in Mapplets.
write a query to follwoing table amount year quarter 254556 2003 first 546332 2003 second 129034 2003 third 490223 2003 fourth 165768 2004 first 265443 2004 second 510412 2004 third 435690 2004 fourth i want the output year q1_amount q2_amount q3_amount q4_amount 2003 254556 546332 129034 490223 2004 165768 265443 510412 435690
I have been working in Informix-4gl for the past 2 years in an MNC company.But I'm interested to work in Business Intelligence tools. Is it possible to change the technology now? I'm really confused, please help me
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
which one is costliest transformation? costliest means occupying more memory. which one Aggregator,sorter,filter,etc..
I've a denormalized table EMP(empno,ename,phone,addr1,addr2,fax,email). Now I want to insert the record into target in the format that, there will be 2 target rows for 1 source record. In target the row needs to be inserted as: ROW1: empno,ename,addr1,phone ROW2: empno,ename,addr2,fax,email And I'm not allowed to normalize transformation. How to achieve?
Teradata 
