Sql Query to get Mappings names under a particular folder from Informatica Database?2019 Community Moderator ElectionHow does database indexing work?How can I prevent SQL injection in PHP?How can I get column names from a table in Oracle?How do I limit the number of rows returned by an Oracle query after ordering?How can I get column names from a table in SQL Server?What are the best practices for SQLite on Android?Getting the SQL from a Django QuerySetGet all table names of a particular database by SQL query?What are the options for storing hierarchical data in a relational database?How to import an SQL file using the command line in MySQL?
Am I not good enough for you?
Know when to turn notes upside-down(eighth notes, sixteen notes, etc.)
How could a scammer know the apps on my phone / iTunes account?
Does this AnyDice function accurately calculate the number of ogres you make unconcious with three 4th-level castings of Sleep?
Bash: What does "masking return values" mean?
Dot in front of file
Could the Saturn V actually have launched astronauts around Venus?
How do I hide Chekhov's Gun?
How do anti-virus programs start at Windows boot?
Should we release the security issues we found in our product as CVE or we can just update those on weekly release notes?
At what level can a dragon innately cast its spells?
How to deal with taxi scam when on vacation?
Theorems like the Lovász Local Lemma?
Co-worker team leader wants to inject his friend's awful software into our development. What should I say to our common boss?
Connecting top and bottom SMD component pads using via
How could a female member of a species produce eggs unto death?
Can anyone tell me why this program fails?
Can hydraulic brake levers get hot when brakes overheat?
Why are the outputs of printf and std::cout different
Does splitting a potentially monolithic application into several smaller ones help prevent bugs?
Humanity loses the vast majority of its technology, information, and population in the year 2122. How long does it take to rebuild itself?
Rejected in 4th interview round citing insufficient years of experience
Counting certain elements in lists
Meaning of "SEVERA INDEOVI VAS" from 3rd Century slab
Sql Query to get Mappings names under a particular folder from Informatica Database?
2019 Community Moderator ElectionHow does database indexing work?How can I prevent SQL injection in PHP?How can I get column names from a table in Oracle?How do I limit the number of rows returned by an Oracle query after ordering?How can I get column names from a table in SQL Server?What are the best practices for SQLite on Android?Getting the SQL from a Django QuerySetGet all table names of a particular database by SQL query?What are the options for storing hierarchical data in a relational database?How to import an SQL file using the command line in MySQL?
Can anyone please help me out
Sql Query to get Mappings names under a particular folder from Informatica Database
sql database oracle informatica informatica-powercenter
add a comment |
Can anyone please help me out
Sql Query to get Mappings names under a particular folder from Informatica Database
sql database oracle informatica informatica-powercenter
Hi Kamal can you elaborate your question please. What do you mean "under a particular folder"
– Jim Macaulay
Sep 13 '16 at 9:11
This question is unclear, please elaborate it otherwise it will be deleted
– Ab_
Sep 13 '16 at 9:12
Here you find something on How to Ask and how to build a Minimal, Complete, and Verifiable example that can be useful to improve your question
– Aleksej
Sep 13 '16 at 9:21
You mean to say you need the mapping name in a separate file?
– Jim Macaulay
Sep 13 '16 at 9:22
add a comment |
Can anyone please help me out
Sql Query to get Mappings names under a particular folder from Informatica Database
sql database oracle informatica informatica-powercenter
Can anyone please help me out
Sql Query to get Mappings names under a particular folder from Informatica Database
sql database oracle informatica informatica-powercenter
sql database oracle informatica informatica-powercenter
asked Sep 13 '16 at 9:06
KamalKamal
115
115
Hi Kamal can you elaborate your question please. What do you mean "under a particular folder"
– Jim Macaulay
Sep 13 '16 at 9:11
This question is unclear, please elaborate it otherwise it will be deleted
– Ab_
Sep 13 '16 at 9:12
Here you find something on How to Ask and how to build a Minimal, Complete, and Verifiable example that can be useful to improve your question
– Aleksej
Sep 13 '16 at 9:21
You mean to say you need the mapping name in a separate file?
– Jim Macaulay
Sep 13 '16 at 9:22
add a comment |
Hi Kamal can you elaborate your question please. What do you mean "under a particular folder"
– Jim Macaulay
Sep 13 '16 at 9:11
This question is unclear, please elaborate it otherwise it will be deleted
– Ab_
Sep 13 '16 at 9:12
Here you find something on How to Ask and how to build a Minimal, Complete, and Verifiable example that can be useful to improve your question
– Aleksej
Sep 13 '16 at 9:21
You mean to say you need the mapping name in a separate file?
– Jim Macaulay
Sep 13 '16 at 9:22
Hi Kamal can you elaborate your question please. What do you mean "under a particular folder"
– Jim Macaulay
Sep 13 '16 at 9:11
Hi Kamal can you elaborate your question please. What do you mean "under a particular folder"
– Jim Macaulay
Sep 13 '16 at 9:11
This question is unclear, please elaborate it otherwise it will be deleted
– Ab_
Sep 13 '16 at 9:12
This question is unclear, please elaborate it otherwise it will be deleted
– Ab_
Sep 13 '16 at 9:12
Here you find something on How to Ask and how to build a Minimal, Complete, and Verifiable example that can be useful to improve your question
– Aleksej
Sep 13 '16 at 9:21
Here you find something on How to Ask and how to build a Minimal, Complete, and Verifiable example that can be useful to improve your question
– Aleksej
Sep 13 '16 at 9:21
You mean to say you need the mapping name in a separate file?
– Jim Macaulay
Sep 13 '16 at 9:22
You mean to say you need the mapping name in a separate file?
– Jim Macaulay
Sep 13 '16 at 9:22
add a comment |
2 Answers
2
active
oldest
votes
you can get mapping_names using this query
SELECT
M.MAPPING_NAME MAPPING,
CASE WHEN M.IS_VALID = 1 THEN 'YES' ELSE 'NO' END IS_VALID,
FROM OPB_MAPPING M, OPB_SUBJECT S
WHERE M.SUBJECT_ID = S.SUBJ_ID
AND is_visible = 1;
So what do you mean under a folder?
hi Jim...i have couple of projects in informatica. i want all mappings of particular project.above query will give mappings of all projects altogether i guess
– Kamal
Sep 13 '16 at 11:07
In this case, you have to manually enter the mapping names in the query. That is the only way as there is no any identifier to represent the mapping name in the database
– Jim Macaulay
Sep 13 '16 at 11:09
If you are creating your mapping in a separate folder you can achieve what you need by querying folder name
– Jim Macaulay
Sep 13 '16 at 11:10
actualy i have queried through folder name ..but i got more mappings in DB as compared to what actuly displaying in front End [ Informatia UI ].But i am suspecting is there is some filter criteria to show the mappings in UI. i want only mappings which are displaying in Informatica UI Screen but in Db it displaying more than actual. i am confuse between isValid,isVisible,version_number columns, like which fields are taken into consideration while displaying in Information UI.
– Kamal
Sep 13 '16 at 11:17
I am using below query SELECT SUBJ.SUBJ_NAME FOLDER_NAME, MP.MAPPING_ID, MP.mapping_name FROM (SELECT * FROM(SELECT M.*,ROW_NUMBER() OVER (PARTITION BY M.MAPPING_ID ORDER BY VERSION_NUMBER DESC) LATEST_VERSION FROM OPB_MAPPING M WHERE NVL(M.REF_WIDGET_ID,0) = 0)WHERE LATEST_VERSION = 1) MP,OPB_SUBJECT SUBJ WHERE MP.SUBJECT_ID(+) = SUBJ.SUBJ_ID AND SUBJ.SUBJ_NAME in ("+folderTitle+")
– Kamal
Sep 13 '16 at 11:19
|
show 14 more comments
You may get this from repository manager by writing a query. Repository Manager -> Tools-> Queries..-> Query Editor -> Query. Thanks !!
add a comment |
Your Answer
StackExchange.ifUsing("editor", function ()
StackExchange.using("externalEditor", function ()
StackExchange.using("snippets", function ()
StackExchange.snippets.init();
);
);
, "code-snippets");
StackExchange.ready(function()
var channelOptions =
tags: "".split(" "),
id: "1"
;
initTagRenderer("".split(" "), "".split(" "), channelOptions);
StackExchange.using("externalEditor", function()
// Have to fire editor after snippets, if snippets enabled
if (StackExchange.settings.snippets.snippetsEnabled)
StackExchange.using("snippets", function()
createEditor();
);
else
createEditor();
);
function createEditor()
StackExchange.prepareEditor(
heartbeatType: 'answer',
autoActivateHeartbeat: false,
convertImagesToLinks: true,
noModals: true,
showLowRepImageUploadWarning: true,
reputationToPostImages: 10,
bindNavPrevention: true,
postfix: "",
imageUploader:
brandingHtml: "Powered by u003ca class="icon-imgur-white" href="https://imgur.com/"u003eu003c/au003e",
contentPolicyHtml: "User contributions licensed under u003ca href="https://creativecommons.org/licenses/by-sa/3.0/"u003ecc by-sa 3.0 with attribution requiredu003c/au003e u003ca href="https://stackoverflow.com/legal/content-policy"u003e(content policy)u003c/au003e",
allowUrls: true
,
onDemand: true,
discardSelector: ".discard-answer"
,immediatelyShowMarkdownHelp:true
);
);
Sign up or log in
StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');
);
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
StackExchange.ready(
function ()
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fstackoverflow.com%2fquestions%2f39466149%2fsql-query-to-get-mappings-names-under-a-particular-folder-from-informatica-datab%23new-answer', 'question_page');
);
Post as a guest
Required, but never shown
2 Answers
2
active
oldest
votes
2 Answers
2
active
oldest
votes
active
oldest
votes
active
oldest
votes
you can get mapping_names using this query
SELECT
M.MAPPING_NAME MAPPING,
CASE WHEN M.IS_VALID = 1 THEN 'YES' ELSE 'NO' END IS_VALID,
FROM OPB_MAPPING M, OPB_SUBJECT S
WHERE M.SUBJECT_ID = S.SUBJ_ID
AND is_visible = 1;
So what do you mean under a folder?
hi Jim...i have couple of projects in informatica. i want all mappings of particular project.above query will give mappings of all projects altogether i guess
– Kamal
Sep 13 '16 at 11:07
In this case, you have to manually enter the mapping names in the query. That is the only way as there is no any identifier to represent the mapping name in the database
– Jim Macaulay
Sep 13 '16 at 11:09
If you are creating your mapping in a separate folder you can achieve what you need by querying folder name
– Jim Macaulay
Sep 13 '16 at 11:10
actualy i have queried through folder name ..but i got more mappings in DB as compared to what actuly displaying in front End [ Informatia UI ].But i am suspecting is there is some filter criteria to show the mappings in UI. i want only mappings which are displaying in Informatica UI Screen but in Db it displaying more than actual. i am confuse between isValid,isVisible,version_number columns, like which fields are taken into consideration while displaying in Information UI.
– Kamal
Sep 13 '16 at 11:17
I am using below query SELECT SUBJ.SUBJ_NAME FOLDER_NAME, MP.MAPPING_ID, MP.mapping_name FROM (SELECT * FROM(SELECT M.*,ROW_NUMBER() OVER (PARTITION BY M.MAPPING_ID ORDER BY VERSION_NUMBER DESC) LATEST_VERSION FROM OPB_MAPPING M WHERE NVL(M.REF_WIDGET_ID,0) = 0)WHERE LATEST_VERSION = 1) MP,OPB_SUBJECT SUBJ WHERE MP.SUBJECT_ID(+) = SUBJ.SUBJ_ID AND SUBJ.SUBJ_NAME in ("+folderTitle+")
– Kamal
Sep 13 '16 at 11:19
|
show 14 more comments
you can get mapping_names using this query
SELECT
M.MAPPING_NAME MAPPING,
CASE WHEN M.IS_VALID = 1 THEN 'YES' ELSE 'NO' END IS_VALID,
FROM OPB_MAPPING M, OPB_SUBJECT S
WHERE M.SUBJECT_ID = S.SUBJ_ID
AND is_visible = 1;
So what do you mean under a folder?
hi Jim...i have couple of projects in informatica. i want all mappings of particular project.above query will give mappings of all projects altogether i guess
– Kamal
Sep 13 '16 at 11:07
In this case, you have to manually enter the mapping names in the query. That is the only way as there is no any identifier to represent the mapping name in the database
– Jim Macaulay
Sep 13 '16 at 11:09
If you are creating your mapping in a separate folder you can achieve what you need by querying folder name
– Jim Macaulay
Sep 13 '16 at 11:10
actualy i have queried through folder name ..but i got more mappings in DB as compared to what actuly displaying in front End [ Informatia UI ].But i am suspecting is there is some filter criteria to show the mappings in UI. i want only mappings which are displaying in Informatica UI Screen but in Db it displaying more than actual. i am confuse between isValid,isVisible,version_number columns, like which fields are taken into consideration while displaying in Information UI.
– Kamal
Sep 13 '16 at 11:17
I am using below query SELECT SUBJ.SUBJ_NAME FOLDER_NAME, MP.MAPPING_ID, MP.mapping_name FROM (SELECT * FROM(SELECT M.*,ROW_NUMBER() OVER (PARTITION BY M.MAPPING_ID ORDER BY VERSION_NUMBER DESC) LATEST_VERSION FROM OPB_MAPPING M WHERE NVL(M.REF_WIDGET_ID,0) = 0)WHERE LATEST_VERSION = 1) MP,OPB_SUBJECT SUBJ WHERE MP.SUBJECT_ID(+) = SUBJ.SUBJ_ID AND SUBJ.SUBJ_NAME in ("+folderTitle+")
– Kamal
Sep 13 '16 at 11:19
|
show 14 more comments
you can get mapping_names using this query
SELECT
M.MAPPING_NAME MAPPING,
CASE WHEN M.IS_VALID = 1 THEN 'YES' ELSE 'NO' END IS_VALID,
FROM OPB_MAPPING M, OPB_SUBJECT S
WHERE M.SUBJECT_ID = S.SUBJ_ID
AND is_visible = 1;
So what do you mean under a folder?
you can get mapping_names using this query
SELECT
M.MAPPING_NAME MAPPING,
CASE WHEN M.IS_VALID = 1 THEN 'YES' ELSE 'NO' END IS_VALID,
FROM OPB_MAPPING M, OPB_SUBJECT S
WHERE M.SUBJECT_ID = S.SUBJ_ID
AND is_visible = 1;
So what do you mean under a folder?
answered Sep 13 '16 at 9:16


Jim MacaulayJim Macaulay
1,1221922
1,1221922
hi Jim...i have couple of projects in informatica. i want all mappings of particular project.above query will give mappings of all projects altogether i guess
– Kamal
Sep 13 '16 at 11:07
In this case, you have to manually enter the mapping names in the query. That is the only way as there is no any identifier to represent the mapping name in the database
– Jim Macaulay
Sep 13 '16 at 11:09
If you are creating your mapping in a separate folder you can achieve what you need by querying folder name
– Jim Macaulay
Sep 13 '16 at 11:10
actualy i have queried through folder name ..but i got more mappings in DB as compared to what actuly displaying in front End [ Informatia UI ].But i am suspecting is there is some filter criteria to show the mappings in UI. i want only mappings which are displaying in Informatica UI Screen but in Db it displaying more than actual. i am confuse between isValid,isVisible,version_number columns, like which fields are taken into consideration while displaying in Information UI.
– Kamal
Sep 13 '16 at 11:17
I am using below query SELECT SUBJ.SUBJ_NAME FOLDER_NAME, MP.MAPPING_ID, MP.mapping_name FROM (SELECT * FROM(SELECT M.*,ROW_NUMBER() OVER (PARTITION BY M.MAPPING_ID ORDER BY VERSION_NUMBER DESC) LATEST_VERSION FROM OPB_MAPPING M WHERE NVL(M.REF_WIDGET_ID,0) = 0)WHERE LATEST_VERSION = 1) MP,OPB_SUBJECT SUBJ WHERE MP.SUBJECT_ID(+) = SUBJ.SUBJ_ID AND SUBJ.SUBJ_NAME in ("+folderTitle+")
– Kamal
Sep 13 '16 at 11:19
|
show 14 more comments
hi Jim...i have couple of projects in informatica. i want all mappings of particular project.above query will give mappings of all projects altogether i guess
– Kamal
Sep 13 '16 at 11:07
In this case, you have to manually enter the mapping names in the query. That is the only way as there is no any identifier to represent the mapping name in the database
– Jim Macaulay
Sep 13 '16 at 11:09
If you are creating your mapping in a separate folder you can achieve what you need by querying folder name
– Jim Macaulay
Sep 13 '16 at 11:10
actualy i have queried through folder name ..but i got more mappings in DB as compared to what actuly displaying in front End [ Informatia UI ].But i am suspecting is there is some filter criteria to show the mappings in UI. i want only mappings which are displaying in Informatica UI Screen but in Db it displaying more than actual. i am confuse between isValid,isVisible,version_number columns, like which fields are taken into consideration while displaying in Information UI.
– Kamal
Sep 13 '16 at 11:17
I am using below query SELECT SUBJ.SUBJ_NAME FOLDER_NAME, MP.MAPPING_ID, MP.mapping_name FROM (SELECT * FROM(SELECT M.*,ROW_NUMBER() OVER (PARTITION BY M.MAPPING_ID ORDER BY VERSION_NUMBER DESC) LATEST_VERSION FROM OPB_MAPPING M WHERE NVL(M.REF_WIDGET_ID,0) = 0)WHERE LATEST_VERSION = 1) MP,OPB_SUBJECT SUBJ WHERE MP.SUBJECT_ID(+) = SUBJ.SUBJ_ID AND SUBJ.SUBJ_NAME in ("+folderTitle+")
– Kamal
Sep 13 '16 at 11:19
hi Jim...i have couple of projects in informatica. i want all mappings of particular project.above query will give mappings of all projects altogether i guess
– Kamal
Sep 13 '16 at 11:07
hi Jim...i have couple of projects in informatica. i want all mappings of particular project.above query will give mappings of all projects altogether i guess
– Kamal
Sep 13 '16 at 11:07
In this case, you have to manually enter the mapping names in the query. That is the only way as there is no any identifier to represent the mapping name in the database
– Jim Macaulay
Sep 13 '16 at 11:09
In this case, you have to manually enter the mapping names in the query. That is the only way as there is no any identifier to represent the mapping name in the database
– Jim Macaulay
Sep 13 '16 at 11:09
If you are creating your mapping in a separate folder you can achieve what you need by querying folder name
– Jim Macaulay
Sep 13 '16 at 11:10
If you are creating your mapping in a separate folder you can achieve what you need by querying folder name
– Jim Macaulay
Sep 13 '16 at 11:10
actualy i have queried through folder name ..but i got more mappings in DB as compared to what actuly displaying in front End [ Informatia UI ].But i am suspecting is there is some filter criteria to show the mappings in UI. i want only mappings which are displaying in Informatica UI Screen but in Db it displaying more than actual. i am confuse between isValid,isVisible,version_number columns, like which fields are taken into consideration while displaying in Information UI.
– Kamal
Sep 13 '16 at 11:17
actualy i have queried through folder name ..but i got more mappings in DB as compared to what actuly displaying in front End [ Informatia UI ].But i am suspecting is there is some filter criteria to show the mappings in UI. i want only mappings which are displaying in Informatica UI Screen but in Db it displaying more than actual. i am confuse between isValid,isVisible,version_number columns, like which fields are taken into consideration while displaying in Information UI.
– Kamal
Sep 13 '16 at 11:17
I am using below query SELECT SUBJ.SUBJ_NAME FOLDER_NAME, MP.MAPPING_ID, MP.mapping_name FROM (SELECT * FROM(SELECT M.*,ROW_NUMBER() OVER (PARTITION BY M.MAPPING_ID ORDER BY VERSION_NUMBER DESC) LATEST_VERSION FROM OPB_MAPPING M WHERE NVL(M.REF_WIDGET_ID,0) = 0)WHERE LATEST_VERSION = 1) MP,OPB_SUBJECT SUBJ WHERE MP.SUBJECT_ID(+) = SUBJ.SUBJ_ID AND SUBJ.SUBJ_NAME in ("+folderTitle+")
– Kamal
Sep 13 '16 at 11:19
I am using below query SELECT SUBJ.SUBJ_NAME FOLDER_NAME, MP.MAPPING_ID, MP.mapping_name FROM (SELECT * FROM(SELECT M.*,ROW_NUMBER() OVER (PARTITION BY M.MAPPING_ID ORDER BY VERSION_NUMBER DESC) LATEST_VERSION FROM OPB_MAPPING M WHERE NVL(M.REF_WIDGET_ID,0) = 0)WHERE LATEST_VERSION = 1) MP,OPB_SUBJECT SUBJ WHERE MP.SUBJECT_ID(+) = SUBJ.SUBJ_ID AND SUBJ.SUBJ_NAME in ("+folderTitle+")
– Kamal
Sep 13 '16 at 11:19
|
show 14 more comments
You may get this from repository manager by writing a query. Repository Manager -> Tools-> Queries..-> Query Editor -> Query. Thanks !!
add a comment |
You may get this from repository manager by writing a query. Repository Manager -> Tools-> Queries..-> Query Editor -> Query. Thanks !!
add a comment |
You may get this from repository manager by writing a query. Repository Manager -> Tools-> Queries..-> Query Editor -> Query. Thanks !!
You may get this from repository manager by writing a query. Repository Manager -> Tools-> Queries..-> Query Editor -> Query. Thanks !!
answered Sep 16 '16 at 6:02
VikasVikas
386
386
add a comment |
add a comment |
Thanks for contributing an answer to Stack Overflow!
- Please be sure to answer the question. Provide details and share your research!
But avoid …
- Asking for help, clarification, or responding to other answers.
- Making statements based on opinion; back them up with references or personal experience.
To learn more, see our tips on writing great answers.
Sign up or log in
StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');
);
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
StackExchange.ready(
function ()
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fstackoverflow.com%2fquestions%2f39466149%2fsql-query-to-get-mappings-names-under-a-particular-folder-from-informatica-datab%23new-answer', 'question_page');
);
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');
);
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');
);
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');
);
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Hi Kamal can you elaborate your question please. What do you mean "under a particular folder"
– Jim Macaulay
Sep 13 '16 at 9:11
This question is unclear, please elaborate it otherwise it will be deleted
– Ab_
Sep 13 '16 at 9:12
Here you find something on How to Ask and how to build a Minimal, Complete, and Verifiable example that can be useful to improve your question
– Aleksej
Sep 13 '16 at 9:21
You mean to say you need the mapping name in a separate file?
– Jim Macaulay
Sep 13 '16 at 9:22