Please help to set up following scenarioI have a source either file or db tableEno ename sal dept101 sri 100 1102 seeta 200 2103 lax 300 3104 ravam 76 1105 soorp 120 2Want to run a session 3 times.First time: it should populate dept 1Second time: dept 2 onlyThird time: dept 3 onlyHow can we do this?

MAHESH MANAM

• Sep 27th, 2012

We can solve this issue by the following types: First, we can create a mapping parameter and run the mapping in each time give the parameter value according to your requirement. Second, we can creat...

dileep671

 Profile Answers by dileep671 Questions by dileep671

• Jul 25th, 2012

Put this query in Source Qualifier select empno, ename, sal, deptno from emp_src where deptno not in (select deptno from emp_trg); Then connect it to Rank Transformation In the properties, Select To...

Answer Question  Select Best Answer

I have 2 workflows named as W1 and W2 so I need to execute W2 but after W1 workflow executed successfully then only executed W2 workflow? How to do this one?

Venkat

• Dec 22nd, 2022

We can trigger W2 after completion of W1 by using pmcmd commands in shell scripting.

Pranav

• Apr 25th, 2019

Can we not use worklet to add two workflows and link them to run one after the another ?

Answer Question  Select Best Answer

Session - A Session Is A set of instructions that tells the Informatica Server How And When To Move Data From Sources To Targets. After creating the session, we can use either the server manager or the command line program pmcmd to start or stop the session.Batches - It Provides A Way to Group Sessions For Either Serial Or Parallel Execution By The Informatica Server. There Are Two Types Of Batches...

Read Best Answer

Editorial / Best Answer

sanghala  

 Profile Answers by sanghala Questions by sanghala

• Member Since Apr-2006 | May 14th, 2007

---

Session:  A session is a set of commands that describes the server to move data to the target.

Batch :  A Batch is set of tasks that may include one or more numbar of tasks (sessions, ewent wait, email, command, etc..,)

There are two types of batches in Informatica:

1. Sequential: When Data moves one after another from source to target it is sequential

2. Concurrent: When whole data moves simultaneously from source to target it is Concurrent

ram_infa

 Profile Answers by ram_infa Questions by ram_infa

• Sep 9th, 2011

Session is nothing, but it tells the integration service, when and how to move the data from sources to target

Group of sessions is called a batch..

ravindra

• Jul 15th, 2011

Session is an object of repository,which instructs the informatica server(integration service)to execute the mapping with given database connection's...

Improve Answer

saiteja

• Jul 24th, 2017

There are 2 types of loading in the Informatica 1) Normal load 2) Bulk load When you configure the load as normal load it process the row by row the normal uses log file for restartability When ...

Anonymous

• Jul 21st, 2016

Can we know what type of loader is used by Informatica to load data in to Oracle database?

Answer Question  Select Best Answer

Chinna

• May 20th, 2013

Using Sorter Transformation it will delete duplicate records and using Expression Transformation... "c S->SQ->EXP->Router->TR.... Exp Logic=V_Prod_id=Prod_id V_Dup_...

Madhuri

• Jun 22nd, 2012

Use sorter transformation after SQ and check the distinct check box of sorter.finally connect to the tgt.

Answer Question  Select Best Answer

Sumanth

• Aug 3rd, 2011

In session properties use the header option and select header output field name

Rakesh

• Jul 28th, 2011

This is a way in informatica itself, follow the below step

In session level, click Edit - > Mapping - > select the tgt file - > goto Header Option -> select 'Output Filed Names'

We are done... u ll find the header names in the flat file. :)

cheers
Rakesh

Answer Question  Select Best Answer

Lingesh Kumar

• Jan 31st, 2007

Hi When ever you load to source load with date timesatmp. Suppose u want ot today records into target table. So source table will have today Date timestamp for all the records which came toda...

jvivek80

• Dec 25th, 2006

Five methods for capturing data changes are available:Use source timestamps. -- Advances in operating systems and RDBMS functionality has enabled us to a large extent to identify record creation and ...

Answer Question  Select Best Answer

Target Types are File, Relational and ERP.

Read Best Answer

Editorial / Best Answer

manojkumar_dwh  

 Profile Answers by manojkumar_dwh Questions by manojkumar_dwh

• Member Since Apr-2007 | Apr 14th, 2007

---

PowerCenter can load data into the following targets:

• Relational. Oracle, Sybase, Sybase IQ, Informix, IBM DB2, Microsoft SQL Server, and Teradata.
• File. Fixed and delimited flat file and XML.
• Application. You can purchase additional PowerCenter Connect products to load data into SAP BW. You can also load data into IBM MQSeries message queues and TIBCO.
• Other. Microsoft Access.

You can load data into targets using ODBC or native drivers, FTP, or external loaders.

saithirumal

 Profile Answers by saithirumal Questions by saithirumal

• Mar 26th, 2011

It may be flat file or relational table.

jayapraveen

 Profile Answers by jayapraveen Questions by jayapraveen

• Oct 4th, 2010

The target types on the server are flat-file, xml, ERP, Cobol etc

Improve Answer

Can identify existing rows of data using unconnected lookup transformation.

Read Best Answer

Editorial / Best Answer

Answered by: SK

• Aug 30th, 2007

---

There are two ways to lookup the target table to verify a row exists or not :
1. Use connect dynamic cache lookup and then check the values of NewLookuprow Output port to decide whether the incoming record already exists in the table / cache or not.

2. Use Unconnected lookup and call it from an expression trasformation and check the Lookup condition port value (Null/ Not Null) to decide whether the incoming record already exists in the table or not.

doppalpaudi

 Profile Answers by doppalpaudi Questions by doppalpaudi

• Jul 9th, 2010

Lookup Transformation is used to cheek weather the data is present in target or not.This transformation is of 2 types 1. Connected lookup transformation2. Unconnected lookup transformation.By using above both we can cheek the target for data .

svivekananda

 Profile Answers by svivekananda Questions by svivekananda

• Jun 26th, 2010

We can use both connected and unconnected lookups to check the existing records in the target table.

Improve Answer

srinivas

• Sep 14th, 2011

In Informatica 8.6, recovery feature is improved. Informatica server writes real time recovery info to a queue which helps maintain data integrity during recovery. So, no data is lost or duplicated. R...

uppala chary

• Aug 28th, 2011

In session properties use session recovery strategy.

Answer Question  Select Best Answer

dl_mstr

 Profile Answers by dl_mstr Questions by dl_mstr

• Feb 10th, 2008

SELECT *FROM (select * from source_table ORDER BY rownum DESC) SourceWHERE rownum <= 501

sreedhark26

 Profile Answers by sreedhark26 Questions by sreedhark26

• Mar 12th, 2007

u can load 500 records, then we can use Transaction control transformation, give the condition for 500 records out of 1000.

Answer Question  Select Best Answer

Router transformation allows you to use a condition to test data. It is similar to filter transformation. It allows the testing to be done on one or more conditions.

pradeeshkumar

 Profile Answers by pradeeshkumar Questions by pradeeshkumar

• Aug 19th, 2010

Router transformation can be said as an extension of filter transformation. Filter allows you to check for a single condition and rejects rows which does not meet the condition.But Router transformati...

YugandharS

 Profile Answers by YugandharS Questions by YugandharS

• Jun 17th, 2010

Router transformation allows you to use a condition to test data. It is similar to filter transformation. It allows the testing to be done on one or more conditions.

Answer Question  Select Best Answer

Maplet is a set of transformations that you build in the maplet designer and U can use in multiple mapings.

sandeepbabu

• Apr 21st, 2014

Maplet is a resuable object,created with business rule using set of transformations and maplet is created with i/p maplet transformation and o/p tarnsformation. Maplet can be created without i/p maplet transformation.

It can be divided into two type:

1)active maplet
2)Passive maplet

abhishek_upadhyay

 Profile Answers by abhishek_upadhyay Questions by abhishek_upadhyay

• Sep 18th, 2008

Basically mapplet is a subset of the mapping in which we can have the information of the each dimension keys by?keeping the different mappings created individually. If we want a series of dimension keys in the final fact table we will use mapping designer.

Answer Question  Select Best Answer

Persistent cache: U can save the lookup cache files and reuse them the next time the informatica server processes a lookup transformation configured to use the cache. Recache from database: If the persistent cache is not synchronized with he lookup table,U can configure the lookup transformation to rebuild the lookup cache. Static cache: U can configure a static or readonly cache for only lookup table.By...

adhoc

• Sep 13th, 2011

There are 2 important caches. 1. Static : By default integration service chooses statyic cache.It is read only cache . when you first query the lookup table, it caches the table. whenever a row com...

Mattock

• Sep 7th, 2011

Caches are of following types:
1. Static Cache
2. Dynamic Cache
3. Persistent Cache
4. Non-persistent Cache
5. Shared Cache
6. Un-shared Cache

More types to follow...:-)

Answer Question  Select Best Answer

In lookup which one is better one connected and unconnected lookup?performance wise i am asking?if i am using five connected lookup in mapping that time what happens?

Ganesh kumar

• Sep 4th, 2013

Yes, I Agree your answer,.....

Baloo_nanduri

 Profile Answers by Baloo_nanduri Questions by Baloo_nanduri

• Jul 25th, 2010

Connected lookup lends best performance and also you can cache or uncache connected look up unconnected look up is used only when you have to use it as a function call both have its own benefits, using 5 connected lookup's is not a big deal until your mapping is tuned well.

Answer Question  Select Best Answer

John

• May 29th, 2013

Sort all the records by country name. in expr transformation include the below variables v_countout=IIF((v_currcountry=vprevcountry),v_count,vcount+1) basically incrementing the count if the country ...

Mahesh Manam

• May 6th, 2013

Using Router transformation we will achieve this.

S -> SQ -> RTR -> T

In router,create 10 groups for 10 countries

Answer Question  Select Best Answer

Mohan

• Aug 12th, 2018

1. You cannot perform DD_Delete unless you have update strategy.
2. While updating a record, ideally created date should not be changed. for that we definitely have to create two targets (insert and update)

vskogirala

 Profile Answers by vskogirala Questions by vskogirala

• Feb 15th, 2008

In update strategy ,1)An insert in the source an insert in the target2)An update in the source is an update in the target update strategy provides 4 types of data driven functions 1)DD_INSERT2)DD_UPDA...

Answer Question  Select Best Answer

Thru informatica how we can load only last 100 records.

Prasad

• Mar 8th, 2016

SQ->exp->filter->target

In expression we need to calculate sequence number then filter records in filter transformation as column>=50 and column

Naveen

• Dec 11th, 2015

Use SQ --> EXP --> RANK --> TGT

In EXP initialize v_count=v_count+1
In Rank Txn, rank on v_count and select BOTTOM 100.

I think, this will work.

Answer Question  Select Best Answer

What are the transformations not used in mapplet and why?

Read Best Answer

Editorial / Best Answer

gazulas  

 Profile Answers by gazulas Questions by gazulas

• Member Since Jan-2006 | Jul 2nd, 2008

---

The following should not include in a mapplet.

• Normalizer transformations
• Cobol sources
• XML Source Qualifier transformations
• XML sources
• Target definitions
• Pre- and post- session stored procedures
• Other mapplets

The exact reason i why these should not used i dont know.

sahan

 Profile Answers by sahan Questions by sahan

• Jul 16th, 2009

Normalizer transformationXML source qualifierXML filesOther targets.If
you need to use sequence generator transformation use the reusable sequence gen t/rIf
you need to use stored procedure transformation, make the stored procedure type as normal.

gaurav2485

 Profile Answers by gaurav2485 Questions by gaurav2485

• Jan 8th, 2009

Non reusable Sequencial Generator also we cannot use

Improve Answer

In which situation do we use unconnected lookup?

Anindya1281

 Profile Answers by Anindya1281 Questions by Anindya1281

• Jul 4th, 2010

  - when we need to call same lookup multiple times in one mapping.For example in a parent child relationship you need to pass multiple child id's to get respective parent id's- when most...

hundwanipankaj

 Profile Answers by hundwanipankaj Questions by hundwanipankaj

• Apr 6th, 2010

Unconnected Lookup is used when lookup is not used in every reecord. Lookup data is called at the point in mapping that needs it.  It can be used in any transformation that support expression. Us...

Answer Question  Select Best Answer