I am having source
ENO ENAME LOC
1 A PUNE
2 B MUMBAI
3 C CHENNAI
Target
ENO ENAME LOC
1 A PUNE
2 B MUMBAI
3 C CHENNAI
If a new record coming from source from same location it should directly go to specified location in target at begining
EX:if Eno with 4 coming from same Pune, It should directly load into the Pune location col with '|' symbol. Help me its very urgent
- 5 Answers
- 9054 Views
- Polaris, Zensar, I also Faced
- E-Mail Answers
Answer Posted / krishna
This is wrong question.please explain question with right
information
| Is This Answer Correct ? | 0 Yes | 2 No |
Post New Answer View All Answers
How do you manage the Parameter files while migrating your data from one environment to another environment?
In informatics server which files are created during the session rums?
What is a joiner transformation?
What are the challenges you have faced in your Project (DWH- ETL)? Explain with example?
Define mapplet?
What are the informatica performance improvement tips
in staging we are merging the data and remove the inconsistants data that type of situation what u will done and type of functions u can use
Define pmcmd command?
Explain direct and indirect flat file loading (source file type) - informatica
what is granularity,what type of granularity we will take in fact tables either lowlevel or highlevel,if two tables having same granularity that is posiable or not
Where is metadata stored?
Informatica settings are available in which file?
What is informatica metadata and where is it stored?
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
In development project what is the process to follow for an etl developer from day1
