How to load top/last 3 record using parameter file in Informatica?

Anil

• Jun 22nd, 2016

Parameter files are meant to standardize business rules we can specify, from what column the data is to be extracted and loaded but I think it is not possible to load top/last 3 record by parameter file?

janardhanan

• Jun 12th, 2016

Using Rank Transformation

Answer Question  Select Best Answer

Why do we need transformations like filter, sorter, Joiner etc when we can do all those tasks with Source Qualifier itself using queries?

anand

• Jul 15th, 2017

Because of whenever we are getting data from tables then src_quli works, not for filedata

jatin

• Jun 8th, 2017

Its because in source qualifier you can make the transformations like join, filter only with homogeneous sources like tables can only joined with tables. But if you have to join a file and a table the...

Answer Question  Select Best Answer

In SCD Type 2 Mapping, I Have 50 Records. How to compare without going record by record?

DEEKSHA

• Mar 12th, 2019

Use joiner transformation, instead of lookup to target table.

Arpit Gautam

• Nov 1st, 2018

Use MD5 check constraint in Expression transformer

Answer Question  Select Best Answer

How can we do incremental loading if the source is flat file?

Jacqueline

• Aug 23rd, 2023

Ratnesh, your answer is fine if we know what the natural keys are but what happens if the file is extremely large and you have no idea what the keys are in the flat file? If that is the case then I ...

Ratnesh

• Dec 31st, 2020

If your source flat file is always full file , based on the natural keys, you can identify the records by lookup on the target table , whether records are existing or new. If records are new, go ahead...

Answer Question  Select Best Answer

Read Best Answer

Editorial / Best Answer

deepthi_97  

 Profile Answers by deepthi_97 Questions by deepthi_97

• Member Since Sep-2009 | Sep 23rd, 2009

---

Cobol files and we use normalizer transformation

deepthi_97

 Profile Answers by deepthi_97 Questions by deepthi_97

• Sep 23rd, 2009

Cobol files and we use normalizer transformation

Prabu

• Jun 22nd, 2007

The mainframe files are Used as VSAM files in Informatica by using the Normaliser transformation

Improve Answer

Mapping designer Tansformation developer Mapplet designer

Sumithav29

 Profile Answers by Sumithav29 Questions by Sumithav29

• Jun 12th, 2009

A transformation is a repository object that generates, modifies, or passes data.  We can create transformations in three ways:1. Transformation Developer - Used for creating reusable transformat...

chandrarekha

• Sep 7th, 2007

Mapping DesignerMaplet DesignerTransformation Deveoper?- for reusable transformation

Answer Question  Select Best Answer

Two ways 1.Drag the port from another transforamtion 2.Click the add buttion on the ports tab.

ASHOK1324

 Profile Answers by ASHOK1324 Questions by ASHOK1324

• Apr 21st, 2009

Ports are columns in Informatica Transformations.Ports can be created in 2 ways.1]. We can drag the ports from source qualifier to any type of transformation.2]. Double click on Header of Transofmrati...

Nitin Rane

• Jun 13th, 2007

We can copy and paste the ports in the ports tab

Answer Question  Select Best Answer

Reusable transformations can be used in multiple mappings.When u need to incorporate this transformation into maping,U add an instance of it to maping.Later if U change the definition of the transformation ,all instances of it inherit the changes.Since the instance of reusable transforamation is a pointer to that transforamtion,U can change the transforamation in the transformation developer,its instances...

devaranr

 Profile Answers by devaranr Questions by devaranr

• Apr 12th, 2007

1. A reusable transformation can be used in multiple transformations2.The designer stores each reusable transformation as metada separate from   any mappings  that use the transformatio...

zaki

• Apr 1st, 2007

Hai to all friends out therethe transformation that can be reused is called a reusable transformation.as the property suggests it has to be reused:so for reusing we can do it in two different ways 1) ...

Answer Question  Select Best Answer

The aggregator stores data in the aggregate cache until it completes aggregate calculations.When u run a session that uses an aggregator transformation,the informatica server creates index and data caches in memory to process the transformation.If the informatica server requires more space,it stores overflow values in cache files.

chandrarekha

• Sep 24th, 2007

when? server runs the session with aggregate transformation ,it stores data in memory until it completes the aggregation when u partition a source ,the server creates one memory cache and one disk ca...

bneha15

 Profile Answers by bneha15 Questions by bneha15

• Apr 18th, 2007

Aggregate cache contains data values while aggregate calculations are being performed. Aggregate cache is made up of index cache and data cache. Index cache contains group values and data cache consists of row values.

Answer Question  Select Best Answer

U can join hetrogenious data sources in joiner transformation which we can not achieve in source qualifier transformation. U need matching keys to join two relational sources in source qualifier transformation.Where as u doesn’t need matching keys to join two sources. Two relational sources should come from same datasource in sourcequalifier.U can join relatinal sources which r coming from diffrent...

divakar

• Nov 5th, 2007

source qualifier is used for reading the data from the database where as joiner transformation is used for joining two data tables.source qualifier can also be used to join two tables but the conditio...

pkonakalla

 Profile Answers by pkonakalla Questions by pkonakalla

• May 23rd, 2007

hi, as per my knowledge, you need matching keys to join two relational sources both in Source qualifier as well as in Joiner transformation. But the difference is that in Source qualifier, both the keys must have primary key - foreign key relation, Whereas in Joiner transformation its not needed.

Answer Question  Select Best Answer

Connected lookupUnconnected lookup Receives input values diectly from the pipe line.Receives input values from the result of a  lkp expression in a another transformation.U can use a dynamic or static cache U can use a static cache.Cache includes all lookup columns used in the mapingCache includes all lookup out put ports in the lookup condition and the lookup/return port. Support user defined...

ASHOK1324

 Profile Answers by ASHOK1324 Questions by ASHOK1324

• Apr 21st, 2009

1]. Connected lookup receives input values directly from mapping pipeline whereas UnConnected lookup receives values from: LKP expression from another transformation.2]. Connected lookup can use ...

Shivat

 Profile Answers by Shivat Questions by Shivat

• Sep 13th, 2006

Hi Differences Between Connected and Unconnected LookupsConnected LookupUnconnected LookupReceives input values directly from the pipeline.Receives input values from the result of a :LKP expressi...

Answer Question  Select Best Answer

In the Type2 maping we have three options to recognise the newly added rows Version number Flagvalue Effective date Range

ASHOK1324

 Profile Answers by ASHOK1324 Questions by ASHOK1324

• Apr 21st, 2009

In the SCD Type2, we have three options to recognise the newly added rows: 1. Version number 2. Flag value 3. Effective Date Range

Prasath

• Oct 4th, 2007

Just use debugger to know how the data from source moves to target, it will show how many new rows get inserted else updated.

Answer Question  Select Best Answer

Two options Run the session only if previous session completes sucessfully. Always runs the session.

Vani_AT

 Profile Answers by Vani_AT Questions by Vani_AT

• Apr 1st, 2008

I would like to make a small correction for the above answer.Even if a session fails with the above property set,all the following sessions of the workflow still run and succeed depending on the valid...

sn3508

 Profile Answers by sn3508 Questions by sn3508

• Aug 24th, 2007

You have to specify those options in the workflow designer.  You can double click the pipeline which connects two sessions and there you can define prevtaskstatus=succeeded. Then only the next se...

Answer Question  Select Best Answer

U can not. If u want to start batch that resides in a batch,create a new independent batch and copy the necessary sessions into the new batch.

Vani_AT

 Profile Answers by Vani_AT Questions by Vani_AT

• Apr 1st, 2008

Logically yes.I have not worked with worklets. But as we can start a single session within a workflow; similarly we should be able to start a worklet within a workflow.

dl_mstr

 Profile Answers by dl_mstr Questions by dl_mstr

• Dec 17th, 2007

Logically Yes, we can craete worklets and call the batch

Answer Question  Select Best Answer

MAHESH MANAM

• Aug 16th, 2012

From flat file you use the following wys: --> In source analyzer you can create file by manually -->you can import file -->you can use any of the flat file and give session properties in that correc...

dileep671

 Profile Answers by dileep671 Questions by dileep671

• Aug 3rd, 2012

Go to Source analyzer , then import XML Source, a wizard opens up.. select the Schema Definition (XSD) of th XML file

When you run the session, give the XML file name and XML file directory path.

Answer Question  Select Best Answer

Ranga Rao

• Aug 4th, 2011

1.you should give the database connection
2.you should provide associated port for all look ports
3.cache size is less
4.not check the dynamic cache option in the properties tab

varun

• Jul 16th, 2011

Can you explain it more clearly means you are saying that the session fails when it is trying to returns more values or more columns

Answer Question  Select Best Answer

Ray

• Mar 22nd, 2006

Always remember when designing a mapping: less for moredesign with the least number of transformations that can do the most jobs.

premlahari

 Profile Answers by premlahari Questions by premlahari

• Dec 13th, 2005

There is no such limitation to use this number of transformations. But in performance point of view using too many transformations will reduce the session performance. My idea is "if needed ...

Answer Question  Select Best Answer

prade

 Profile Answers by prade Questions by prade

• Jun 26th, 2008

In case of a source based commit, the integration services generates a commit row from the active sources and writes the rows into the target. The number of rows processed from the "active source...

vivek1708

 Profile Answers by vivek1708 Questions by vivek1708

• May 11th, 2008

I dont think above written statement is correctMyunderstanding is that for source based commit: a session as soon as it reads 10k rows from the source it performs a commitand similarly for tbc: as soon as it write 10k rows to targt it does a commit

Answer Question  Select Best Answer

babushiv

 Profile Answers by babushiv Questions by babushiv

• May 24th, 2010

The Type 2 Dimension Data mapping inserts both new and changed dimensions into the target. Changes are tracked in the target table by versioning the primary key and creating a version number for each ...

Rob

• Apr 25th, 2006

1. Determine if the incoming row is 1) a new record 2) an updated record or 3) a record that already exists in the table using two lookup transformations. Split the mapping into 3 seperate flows using...

Answer Question  Select Best Answer

prasadns26

 Profile Answers by prasadns26 Questions by prasadns26

• Jul 18th, 2006

hi,if ur database is teradata we can do it with a tpump or mload external loader.update override in target properties is used basically for updating the target table based on a non key column.e.g upda...

Raajavarman

• Mar 11th, 2006

         By default all the rows in the session is set as insert flag ,you can change it in the session general properties -- Treate source rows as :update...

Answer Question  Select Best Answer