Explain about Informatica Power Exchange
What are the important points in Informatica Power Exchange

Shubham R Lashkar

• Sep 22nd, 2022

Informatica PowerExchange is a family of products that enables an IT organization to retrieve all sources of enterprise data without having to develop custom data-access programs. By accessing mission...

Answer Question  Select Best Answer

Rajesh

• Aug 22nd, 2022

ODS is mainly used to integrate the data of different Sources having same functionality of the data into one integrated model. This model is mostly denormalized and will not be useful for reporting. E...

Ankush

• May 18th, 2017

You mentioned ODS comes after staging area is not true i guess. Flow is like ODS->staging->DWH as per my knowledge. Kindly correct me if wrong.

Answer Question  Select Best Answer

i/p col1||val1||col1||val2||col3||val3
o/p col1 col2 col3
val1 val2 val3
how to achieve this in AB initio

Sneha

• Jun 2nd, 2023

REFORMAT(input column :F1) let int C_FLAG = 0 out :: reformat(in) begin let int count = next_in_sequence(); if count%2 != 0; C_FLAG = string_substring(in.F1,4,1); end; out.COL1 :: if((coun...

Answer Question  Select Best Answer