source: target:
col1 col2 col1 col2

a 1 1 a,b,c,d
b 1 2 p,q,r
c 1 3 x
d 1
p 2
q 2
r 2
x 3

how to do this...

Thanks,
krishna.

rashmi

• Aug 12th, 2017

We can use aggregator transformation.say col1=Nme,col2=ID
Make new_name and new_no as variable port.Specify condition as New_name=IIF(new_no=ID,new_name||,||name,name)
new_no=ID
Give one output port say Output_name =New_name

suresh

• Apr 30th, 2017

I have to pivot the source data from column to rows till "transform" value, "transform" value can occurs any one of the columns, please advice me suggestions, Can any one help me how to achieve the be...

Answer Question  Select Best Answer

Source:
col2 col1
a 1
b 1
c 1
d 1
p 2
q 2
r 2
x 3

how to do this...
thanks
krishna

Manjunath

• Apr 9th, 2015

Converting rows into columns is de-normalizing, you may have to use aggregate transformation to do so. Note: vice verse is normalizing the data, that can be done using normalizer transformation. U...

Shiva

• Jan 14th, 2015

Pivoting means converting rows to column and vise verse.

Please use normalization transformation to achieve this.

Answer Question  Select Best Answer

Under what conditions selecting sorted input in aggregator will still not boost session performance ?

Venkateswara Rao

• Oct 14th, 2014

If all the rows belong to the same data group . Then it doesn't improve anything

Knonw

• Sep 16th, 2014

If in session property Incremental agg. is enabled. 2. in case of Nested aggregation 3. if treat row as data driven is selected in session property. In all of above cases aggrigator performance wil not be boosted up though its using sorted i/p.

Answer Question  Select Best Answer

Design mapping to load the first record from a flat file into Table A, the Last record from a flat file into Table B, and remaining record into Table C

Nagendra

• Nov 5th, 2015

Append Seq Gen after SQ, add sorter, make it desc based on Sequence generated and use a variable to make first row as 0 then by using router route SEQGEN = 1 to A (First Row), Variable =0 to B (Last Row) and rest to C

sum

• Oct 8th, 2015

Use aggregator to take count of rows; then again join this aggregator to source pipeline using dummy columns. Now add one sequence generator and add next_val as srnum from it to each source columns...

Answer Question  Select Best Answer

If both source have same rows, same number of columns and no duplicate which one should be choosen to be master in joiner trasnformation

Kiran

• Feb 2nd, 2016

When we drag first source into a joiner, Integration services treat them as detail, later source when dragged into the joiner, it is treated as master, There is one more check may b we can consider,...

kiran

• Nov 14th, 2015

Integration service can calculate the least number of records that should be in a master

Answer Question  Select Best Answer

Which of the following statements is correct on workflow events?

1) A predefined (or file-wait) Event Wait task waits for a file to appear at the specified location. As soon as the file appears, the event succeeds and the file can be processed by the subsequent mapping.

2) A predefined (or file-wait) Event Wait waits for a file to appear at the specified location. As soon...

Visal

• Aug 14th, 2016

Event wait will be completed once the specified event occurs or in other words, it will wait for the event-raise activity to raise that particular event. You can create an event-raise to poll for a ...

milind

• Jul 12th, 2016

There are options which we have to select eg. to delete file after reading etc.,

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