Hi Experts, I have a source table like this. Name Number Raj 2 Ram 1 Sam 2 John 1 In the target I need the ouptput like the below Raj Raj Ram Sam Sam John We dont know the number value . It will be changing as n.. Please help me regarding this. Thanks, Nataraj V2 5522
I have name like INDIA in a column. I want display 1st line A, 2nd line N, 3rd line D, 4th line I, 5th line A in oracle data base?1 7186
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 urgent5 6933
If i havee 3records in my source having same deptno like Deptid Deptno ------ ------ 101 10 201 10 301 10 and i am using router TR to loading these records into target.Then how many record'll be loaded into target???5 8091
Hi All, I have three question. 1) How to remove the header and footer in a flat file in informatica? 2)How to load the first and last record of flat file into the target? 3)I have a Input and Output table. Input Name Salaray Month A 100 Jan A 200 Feb A 300 March B 400 April B 500 May B 600 June Output Name Salaray Month A 100 Jan A 300 Feb A 600 March B 400 April B 900 May B 1500 June How to implement and get the ouput as mentioned above. If Possible kindly provide the SQL query also. Kindly any one help to implement this concept. Thanks, Pradeep3 12769
delete data from staging table as it loads to target table.here is the case we are getting data from 3 different server.a b and c.the data from server A loaded into staging table and we ran the task and data loaded to target table.now today data from server B and C also got loaded to the staging table.now what techniques and what transformations should be used to delete only the data which has been loaded only to the target.we need to delete only that data from staging which has been loaded into the target.looking for your responses2 3893
IF Sorce table contains CLOB as its one data type then i get error at the target table. How can this be resolve?2 4213
I have one source table and three target tables. When the session runs for the first time involving the mapping,i want that the loading should take place in 1st Target table only. The 2nd time the same session runs the loading should take place in 2nd Target only only and similarly when the session runs for the 3rd time loading should take place in Third only. And again when the session runs for the 4th time loading should take place in 1st Target table.4 10036
what is the difference between mapplet & stored procedure?1 4230
Hi I'm new in Informatica. Can you show me a mapping sample on how to piviot the records? Thanks Robin1 3337
scenario where i can use only concurrent execution of workflow.2028
How can we reset Sequence Generator, when we move objects from Dev Environment to QA env?2 7199
How to Display top 2 salaries for each department WITHOUT using Rank Transformation And WITHOUT using SQL queries in source qualifier.3 10478
how to send unique records to one target and duplicate records to another target by using dynamic lookup cache????? please explain me briefly///(when we use this we look up on which target unique target ya duplicate target)3 9765
How are the sources and targets definitions imported in informatica designer?
Explain lookup transformation source types in informatica
How many ways are there to do 'remove duplicate records in informatica'?
What is the reusable transformation?
What is a shortcut and copy in Informatica and how two are different with each other?
What all join we can perform in LOOKUP transformation?
Can we get 1st record through Informatica(without sequence number).
hi friends ... i have insurance project(informatica),can you please tell me how many table and mappings we need to use?and explain me.. thank you
Explain transaction control transformation in informatica
scenario where i can use only concurrent execution of workflow.
What is the different lookup cache(s)?
What are the modules in Power Center
What is a stored procedure transformation?
What is aggregate cache in aggregator transformation?
Explain the shared cache and re-cache?