1. Categories >> Software >> Data Warehouse >> Informatica
  2. Suggest New Category

can you use flat file for repository?why?

Question Posted / ramu

Answers were Sorted based on User's Feedback



can you use flat file for repository?why?..

Answer / gyana

No..its not possible..in repository two operations are
working..one is storing and again retrieving
also..so..storing we can do in flat file but the retrieval
is important that we can't do if u use flatfile as your
repository..

Is This Answer Correct ?    1 Yes 2 No

can you use flat file for repository?why?..

Answer / gyana

No..its not possible..in repository two operations are
working..one is storing and again retrieving
also..so..storing we can do in flat file but the retrieval
is important that we can't do if u use flatfile as your
repository..

Is This Answer Correct ?    0 Yes 2 No

Post New Answer

More Informatica Interview Questions

What are the types of lookup transformation?

0 Answers   Informatica,

How can u work with remote database in informatica?did you work directly by using remote connections?

2 Answers  

in which situations do u go for sequence generator ?

2 Answers   TCS,

How will restrict values in 0-9 and A-Z and a-z and special character.Only allowed these chars otherwise we will reject the records? what is the function we used to restrict...

1 Answers   Cap Gemini,

Explain the types of lookup transformation?

0 Answers  




My source is like bellow F.NAME M.NAME L.NAME A B C D E F G H I and out put should like S.NO F.NAME M.NAME L.NAME 1 A B C 2 D E F 3 G H I 4 UNNOWN UNNOWN UNNOWN How can we acheive? please explane me indetail

2 Answers   Amdocs,

how to load the data in fact table.. using look up transformation how to view the second record. usally look up shows matching record for only one value. if i have same value its not displaying. ex: problem i faced. i have total, student no and name in table student i used aggregation transformation to display max(total). i have two same max values in total. when i look up the student name and no for this max(total), its showing only one name and no, its leaving the second one. how to rectify it. plz tel me step by step or clearly.

1 Answers  

In real time scenario where can we use mapping parameters and variables?

4 Answers   CSC, CSE,

How the dimensions will be loaded?

0 Answers   HCL,

How i can Schdule the Informatica job in "Unix Corn Schduling tool" ?

2 Answers  

What is informatica? What exactly are the practical uses in real world

2 Answers  

Please let me know how to make Data masking in informatica..

0 Answers  

For more Informatica Interview Questions Click Here
Categories