Hi, I am new to Informatica, What is a flat file and how to
use flat file in infomratica please help me.
Answer Posted / venkadesh
IT IS NOTHING BUT TEXT DOCUMENT SO WE TAKE AS SOURCE FILE.
AFTER THAT WE LOAD IN SOURCE TABLE. BY CLICKING SOURCE MENU
AND SELECT IMPORT FILE
| Is This Answer Correct ? | 3 Yes | 5 No |
Post New Answer View All Answers
Which is the t/r that builts only single cache memory?
What is DR strategy for Informatica project?
What do you mean by blocking transformation?
Quickly characterize reusable change?
What is confirmed fact in dataware housing?
Hi, I saw one mapping implemented by my seniors . In Expression transformation they implemented following logic. That is iif(is_date(in_UC_DATINV,'YYYYMMDD'),to_date(in_UC_DATINV,'Y YYYMMDD'),'Inventory Date is either invalid or null') Inventory_Date is validated only for is_date() But not validated for notisnull() . But error says “ either invalid or null “ why? Whether is_date() also check for not isnull() ? or in this logic something is different ? Please answer me . Advance thanks
what are factless facts? And in which scenario will you use such kinds of fact tables.
how will u take the data from clint server and next what u do in datamodeling what u will u do in staging area what u will u do next what u are doing please give the step by step by process
What is a pre-defined event and user-defined event?
What are the transformations that are not supported in mapplet?
Why is sorter an active transformation?
Explain about Informatica server process that how it works relates to mapping variables?
What all join we can perform in LOOKUP transformation?
what is size of u r database?
Hello, Can you please send the admin and advanced mapping design sample questions to ns_sharmin@yahoo.com?