From where you extract the data, how you did it into
informatica? explain....
- 1 Answers
- 5705 Views
- Accenture, Unisoft Infotech, I also Faced
- E-Mail Answers
Answer / davankumar
Its imp ??? every company should ask these ???.If source is
relation tables source data is relational (ie means oracle
9i/10g)
But source is flat that can in unix server(client can give
path details ).in informatica we have to create the
sturuture of table and give that path address in the
session property tab.
| Is This Answer Correct ? | 4 Yes | 0 No |
I have a source either file or db table Eno ename sal dept 101 sri 100 1 102 seeta 200 2 103 lax 300 3 104 ravam 76 1 105 soorp 120 2 Want to run a session 3 times. First time: it should populate dept 1 Second time: dept 2 only Third time: dept 3 only How can we do this?
How can we use mapping variables in informatica? Where do we use them?
How to Join Tables my Source is having 15 table target is one?
My source data like... Empid Name 10 chandra 10 sekhar I am expecting result is Empid Ename 10 Chandrasekhar How can we solve this prob?
explan ur project architecture?
yesterday my session run ten min.today its run 30min, wt is the reason? if any issues how to solve that?
How to load data into 3 target tables which are in different schema but with the same name and same relational connection at infromatica level ? How to differentiate while loading ? and how to load ?
my source contain data like this cno cname sal 100 rama@gmail.com 1000 200 karuna@yahoo.com 2000 i want load my data to the target is cno cname sal 100 rama 1000 200 karuna 2000 plz send the answer
Let’s say I have more than have record in source table and I have 3 destination table A,B,C. I have to insert first 1 to 10 records in A then 11 to 20 in B and 21 to 30 in C. Then again from 31 to 40 in A, 41 to 50 in B and 51 to 60 in C……So on up to last record.
i have a table like empid ename year month sal 1 x 98 jan 500 1 x 98 feb 500 1 x 98 mar 500 1 x 99 jan 600 1 x 99 feb 600 2 y 98 jan 600 2 y 98 feb 600 2 y 98 mar 600 2 y 99 jan 700 2 y 99 jan 700 and so on i want to find out totsal for every emp on year wise plz help me
what are 3 tech challenges/ common issues you face?
Hi, What is version control in Informatia ? Can anyone just give an idea or introduction about this? Advance Thanks
Teradata 
