Interested to Buy Any Domain ? << Click Here >> for more details...
In a scenario I want to change the dimensions of a table and
normalize the denomralized table which transformation can I use?
- 4 Answers
- 8863 Views
- I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / rajkumar_bachu
By using Normalizer transformation we can normalize the data.
| Is This Answer Correct ? | 2 Yes | 1 No |
Answer / gvmahesh
By using Sequencegenerator T/R we can normalize the
denormalized tables.
Because, By using SEQ T/R we can generate surrogatekey
column.then we can define that as Primarykey column.
| Is This Answer Correct ? | 0 Yes | 0 No |
what is normalization? explain 1st NF, 2nd NF, 3rd NF
when load type is selected as bulk or normal in session level ?let me know the internal process and give me an example?
Can you copy the session to a different folder or repository?
I am having source ENO ENAME LOC 1 A PUNE 2 B MUMBAI 3 C CHENNAI Target ENO ENAME LOC 1 A PUNE 2 B MUMBAI 3 C CHENNAI If a new record coming from source from same location it should directly go to specified location in target at begining EX:if Eno with 4 coming from same Pune, It should directly load into the Pune location col with '|' symbol. Help me its very urgent
I want skip first 5 rows to load in to target? what will be the logic at session level ??
What are the types of schemas we have in data warehouse.
Hi Friends, How i could convert a cobol file (VSAM) into the flat file? How i could edit a cobol source file (VSAM)? I want to introduce few columns in the source file and finally the target should be in the Cobol itself. Kindly suggest me friends. Thanks in Advance, Innai
Hi Experts , Can you please help me regarding the below question How to remove first three rows and last three rows in informatica.. thanks and regards Natraj
my source is like this id,name sal 10 abc 1000,10 pqr 2000, 10 xyz 3000 ,10 jkl 4000 and my requirement is like this 10 abc,pqr,xyz,jkl 2000 .... i have try for this by using expression transformatin its ok of the concatenation of second column but the thing is that on third column if u group by using agg t/r the last value will com i.e 4000 but i asked by a interviewer that i dont want the first or last column i want the middle column i.e 2000 .plz reply for the same
What are the validations that you can perform in oracle and in informatica ? Advance Thanks
If in a workflow i have n number of sessions and each session is configured with different different stop on errors (say 5,8,10 etc respectively).How can make all this same for all the sessions with out actualy touching each and evry session ?
how to find the 5th highest salary form each department using 1.SQL Query 2. Informatica power center designer?
Teradata 
