Answer Posted / mike
A synonym is a alternative name for objects such as tables,
views, sequences , stored procedures and other database
objects.
| Is This Answer Correct ? | 2 Yes | 1 No |
Post New Answer View All Answers
if i hv 6 table as source table but can i make 12 as a dim table and 6 as fact table belongs to that src table.
how to create user defined function (udf) in informatica
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 the limitations of joiner transformation?
Describe the impact of several join conditions and join order in a joiner transformation?
my source is junk data how will u remove that junk data by using unix please any one replay me
Define sessions in informatica etl?
What are the types of schemas we have in data warehouse and what are the difference between them?
What are the differences between joiner transformation and source qualifier transformation?
What are the reusable transformations?
Source and Target are flat files, Source table is as below ID,NAME 1,X 1,X 2,Y 2,Y On Target flat file i want the data to be loaded as mentioned below ID,NAME,REPEAT 1,X,2 1,X,2 2,Y,2 2,Y,2 How to achieve this, Can i get a map structure
I have two different source structure tables, but I want to load into single target table? How do I go about it? Explain in detail through mapping flow.
What are the various test procedures used to check whether the data is loaded in the backend, performance of the mapping, and quality of the data loaded in informatica?
4 yrs etl devloper roles and responsibilities?any body give solutions
How can one identify whether mapping is correct or not without connecting session?
