Skip navigation
Contact Us
990 Views 5 Replies Latest reply: Dec 11, 2012 1:10 AM by Viral Raichura RSS
Mubbasher Syed Newbie 5 posts since
Jun 16, 2011
Currently Being Moderated

Dec 8, 2012 10:18 PM

Hi gurus please help me with this scenario

Hi Freinds,

 

My requirement is that i have a source table say

 

DEPT:

DNAME                                                                             FILE1           FILE 2

ACC                                                                                  ACC             SALES

SALES                                                                               ACC                                                                 

MARKETING                                                                       ACC                                                                   

RESEARCH

ACC

ACC

AND MY SOURCE TABLE DNAMES ARE DYNAMIC IN NATURE AND ACCORDING TO THE NAME OF THE DEPATMENT  IT SHOULD CREATE A TARGET FILE AND LOAD THE DNAME IN THAT FILE

 

How can we acheive this requirement .

 

 

My second question  is if we define two parameter at workflow level and session level  and give

 

wf level : source connection :null and tgt connection : value and

session  level :source connection :value and tgt connection :null  will it work if not how to make it work?

More Like This

  • Retrieving data ...

Bookmarked By (0)

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points