Interested to Buy Any Domain ? << Click Here >> for more details...
From where you extract the data, how you did it into
informatica? explain....
- 1 Answers
- 6104 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 |
In a scenario I want to change the dimensions of a table and normalize the denomralized table which transformation can I use?
i have a source table ID NAME SAL 101 A 1000 102 B 2000 103 C 1500 target load should be ID NAME SAL 101 A 1000 101 B 2000 101 C 1500 102 A 1000 102 B 2000 102 C 1500 103 A 1000 103 B 2000 103 C 1500
Hi, I am new to Informatica, What is a flat file and how to use flat file in infomratica please help me.
difference between repository database and repository service?
Can we have a Mapping without a Source Qualifier?
how can u connect client to ur informatica sever iff server is located at different place( not local to the client)
What are the data movement modes in informatcia?
In which circumstances that informatica server creates Reject files?
Differnce between filter and router?
how to duplicates from expression transformation without using sorter before that
my source is like this id,name sal 10 abc 1000,10 pqr 2000, 10 xyz 3000 ,10 jkl 4000 and my requirement is like this 10 abc,pqr,xyz,jkl 2000 .... i have try for this by using expression transformatin its ok of the concatenation of second column but the thing is that on third column if u group by using agg t/r the last value will com i.e 4000 but i asked by a interviewer that i dont want the first or last column i want the middle column i.e 2000 .plz reply for the same
from Source 100 rows are coming, on target there are 5 m rows which options is better to match data 1. Joiner 2 No cache 3. Static 4. Dynamic
Teradata 
