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
- 6173 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 |
One flatefile it contains some data but i want to dont want to load first and last record ..how it is? can u tell me complete logic?
how remove 1st 3 records & last 3 records in informatics
can anybody send me some real time screenshots of mapping in informatica powercenter. i will be vary thankful to him. my e-mail id :- prakashkumar.kumhar@gmail.com
Where should yoU place the flat file to import the flat file defintion to the designer?
How can i send first half of the records to one target and Remaining to other target?
why normalizer transformation can not used in mapplet? plzzzz answer
what is incremental loading ?
12 Answers CTS, IBM, Oracle, TCS,
Can anyone tell me, when a flat file contains different kinds of delimeters available for each line ( For Ex: First line contains [,*&#$] and second line contains [%@$#%^]. Like that all records having different kinds of delimeters. How can we implement this kind of flat file in informatica?
What all join we can perform in LOOKUP transformation?
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
How do you avoid duplicate records with out using source qualifier,expression,aggrigator,sorter and lookup transformations ?
What are the different types of code pages available in informatica & how to implement it in your project?
Teradata 
