my Source is like:

Sno Name
1 XXXX
2 YYYY

I want the Target like:

Sno Name Frequency
1 XXXX 1
2 YYYY 2
2 YYYY 2

How can I replicate the "2 YYYY".
I am supposed to make it dynamic for all possible frequencies.

Visal

• Aug 14th, 2016

From what I understood from the scenario given above, you want to duplicate some particular type of record. use Router and write the same condition (say column1=2) for both output group. Remember defa...

Answer Question  Select Best Answer

Sandip More

• Mar 3rd, 2013

You can interact with another co-operating system with setting below parameters in .abinitiorc of existing coperating system : AB_NODE : Node at which this another co-operating system resides AB_HOME...

Answer Question  Select Best Answer

What is external table in oracle?How oracle read flat file?

sheraz baig

• Nov 20th, 2013

External Tables let you query data in a flat file. In 9i, only read operations were permitted; in 10g, you can also write out data to an external table. While external tables can be queried, theyre no...

Answer Question  Select Best Answer

How union transformation is active?

jignesh

• Jan 2nd, 2015

No doubt union transformation will give you the result as a passive transformation with same number of records,But row number of the records will get changed in output result set.....eg we have table ...

Answer Question  Select Best Answer

Harsh

• Dec 2nd, 2014

Alter index rebuild;

Answer Question  Select Best Answer

I have a file with 1000 rows I need to split this file that each 100 row is split by a header, to make more clear I need to concatenate the header after 100 row

Harsha

• Feb 7th, 2018

Take the input to sequential file ,in that in filter opinion mention head -100 and output connect it to column import where you mention the schema of input and mention the output schema u need ..so it concatenates entire thing into single row/column.

Correct me if im.wrong.

Answer Question  Select Best Answer

sithusithu

 Profile Answers by sithusithu Questions by sithusithu

• Jan 12th, 2006

Validation Strategies Data validation strategies are often heavily influenced by the architecture for the application. If the application is already in production it will be significantly harder to bu...

Answer Question  Select Best Answer

raja

• Oct 12th, 2006

hi    i am not sure,To my knowledge  it is of  4 or 5 GB

Answer Question  Select Best Answer

Visitor

• May 9th, 2006

Define the variables in Start script and use them in graph. All enviroment variables which have been exported in the shell which is invoking abinitio (  eg. all variables exported in .profile ) will also be available in Abinitio graph.

Answer Question  Select Best Answer

opbang

 Profile Answers by opbang Questions by opbang

• Sep 22nd, 2006

In DWH loops may exist between the table. If loops exist, then query generation will take more time, because more than one path is available. It creates ambiguity also. Loops can be avoided by creatin...

Answer Question  Select Best Answer

bala

• Jul 25th, 2006

Error Log in Informatica is a one of output file created by Informaica Server while running the session for error messages. It is created in Informatica's home directory.

Answer Question  Select Best Answer

Sravan Gopisetty

• Sep 24th, 2006

Cache are stored in Repository.

Answer Question  Select Best Answer

madarapu

 Profile Answers by madarapu Questions by madarapu

• Jul 3rd, 2007

Clustering means grouping of systems where each system has its own resources where as mpp massively parallel processing in this each system has its own memory and diskspace which is also called sharing nothing architecture 

Answer Question  Select Best Answer

How is SCD helpful in real time? Give example by taking banking project.

rummyraj

 Profile Answers by rummyraj Questions by rummyraj

• Oct 13th, 2010

Customer dimension is a good example. Customer address and Phone number frequently changes. So you will update the customer dimension for these changes.Hence its called as SCD. There are several types though. This example is type1 SCD.

Answer Question  Select Best Answer

When do we use Degenerated Dimension?

pradeep reddy gade

• Jul 21st, 2011

Any values in the fact table that dont join to dimensions are either considered degenerate dimensions or measures

Answer Question  Select Best Answer